oracleÊý¾ÝÇ¨ÒÆÎÊÌâ
¹«Ë¾Êý¾Ý¿â·þÎñÆ÷ÊÇÔÚ32λwin2003£¬°²×°ÁË32λµÄoracleÊý¾Ý¿â
ÏÖÓÐÁíһ̨»úÆ÷Ϊ64λwin2003£¬°²×°ÁË64λµÄoracleÊý¾Ý¿â
Èç¹û½«32λ»úÆ÷ÉϵÄÊý¾Ý¿âÊý¾ÝÇ¨ÒÆµ½64λϵÄoracleÊý¾Ý¿âÖÐ
ÓÃ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µÄ»°¿ÉÒÔÓÃÊý¾Ý±Ã
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
oracle not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html
Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..
cm ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......
´ó¼ÒºÃ£¬ÔÚ¿ª·¢µÄʱºò£¬Óöµ½ÕâÑùµÄÎÊÌ⣺
δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342¡±»òËüµÄijһ¸öÒÀÀµÏϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£ ......