oracleÊý¾ÝÇ¨ÒÆÎÊÌâ
¹«Ë¾Êý¾Ý¿â·þÎñÆ÷ÊÇÔÚ32λwin2003£¬°²×°ÁË32λµÄoracleÊý¾Ý¿â ÏÖÓÐÁíһ̨»úÆ÷Ϊ64λwin2003£¬°²×°ÁË64λµÄoracleÊý¾Ý¿â Èç¹û½«32λ»úÆ÷ÉϵÄÊý¾Ý¿âÊý¾ÝÇ¨ÒÆµ½64λϵÄoracleÊý¾Ý¿âÖÐ
ÓÃexpdp´Ó32λµÄÊý¾Ý¿âµ¼³öÊý¾Ý,ÓÃimpdpµ¼Èëµ½64λÊý¾Ý¿âÖÐ.ÒýÓà ÓÃexpdp´Ó32λµÄÊý¾Ý¿âµ¼³öÊý¾Ý,ÓÃimpdpµ¼Èëµ½64λÊý¾Ý¿âÖÐ. ¶ÔÓÚ¿ç°æ±¾µÄÊý¾Ý°áǨ£¬expdp/impdp(10g²ÅÓÐ)£¬ exp/imp ÊǺܺõŤ¾ß¡£ Oracle 10g EXPDPºÍIMPDPʹÓÃ˵Ã÷ http://blog.csdn.net/tianlesoftware/archive/2009/10/15/4674224.aspx exp imp ¶¼ÊÇ10gµÄ»°¿ÉÒÔÓÃÊý¾Ý±Ã
Ïà¹ØÎÊ´ð£º
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
´ó¼ÒºÃ£¬ÔÚ¿ª·¢µÄʱºò£¬Óöµ½ÕâÑùµÄÎÊÌ⣺ δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342¡±»òËüµÄijһ¸öÒÀÀµÏϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£ ......
µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£ ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü: "DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......
Óиö´æ´¢¹ý³ÌÓÐÈý¸öInt²ÎÊýºÍÒ»¸öOut²ÎÊý. Ö´ÐÐʱÏȽ«Ò»Ð©Êý¾Ý²åÈëµ½Ò»¸ö±íÖÐ.È»ºóÔÙ´Ó±íÖÐÈ¡³öÊý¾Ý½øÐÐÐÐתÁÐ,ºÏ¼ÆµÈÂß¼.½«´¦Àí½á¹û·Åµ½Ò»¸ö±íÖÐ.²¢½«Idͨ¹ýOut²ÎÊý·µ»Ø. µ«ÔÚÖ´ÐÐʱ¿ÉÒÔ»ñÈ¡µ½OutÖµ,µ«¾ÍÊÇà ......
oracle°²×°Ê±£¬ÔÚ½øÐмì²âʱ£¬ÌáÊ¾ÍøÂç¼à²âδ³É¹¦£¬ÐèÒª°²×°ÐéÄâÍø¿¨ µ«ÊÇÎÒÃǰ칫ÊÒͬÑùÅäÖõÄÁ½Ì¨µçÄÔ£¬ÎªÊ²Ã´Ò»Ì¨³öÏÖÍøÂç¼à²âδ³É¹¦£¬¶øÁíһ̨»ú×Ó¾ÍûÓгöÏÖÕâÖÖÇé¿ö ÔÚʲôÇé¿öÏ£¬»á³öÏÖÍøÂç¼à ......