åºæ¯ï¼
æå¡å¨æ¯linux ç 线ä¸æ¯Oracleçï¼æ¬å°å¼åç¯å¢æ¯WIN7ï¼æ³å»çº¿ä¸å¯¼åºä¸ä»½ææ°çæ°æ®åºï¼ç¶åå¨æ¬å°ä½¿ç¨å¯¼å
¥ï¼ç¶åæ§è¡æ¥éª¤å¦ä¸ï¼
1.
/home/app/oracle/product/11.2.0/db_1/bin/expdp "'/as sysdba'" DUMPFILE=schemas_20130623.dmp DIRECTORY=DATA_PUMP_DIR SCHEMAS=ï¼ï¼ï¼ parallel=2 version=11.2.0.1.0
解éï¼
SCHEMAS=è¦å¯¼åºçç¨æ·ï¼éå·åé
导åºå°äºç®å½ä¸"
ç¨è¿å¥è¯æ¥æ¾ï¼
select DIRECTORY_PATH from dba_directories where DIRECTORY_NAME='DATA_PUMP_DIR';
ç»æ为
/home/app/admin/orcl/dpdump/
并å¨æ¤ç®å½ä¸æ¾å°äºschemas_20130623.dmpæ件 ç¨SSHä¸è½½å°æ¬å°
并å°æ件æ¾å°ï¼
ç¨è¿å¥è¯æ¥æ¾ï¼
select DIRECTORY_PATH from dba_directories where DIRECTORY_NAME='DATA_PUMP_DIR';
ç»æ为
E:\oracle11g\app\oracle\admin\xe\dpdump\
æ¾å°ä¸é¢çç®å½ä¸
ç¨å¯¼å
¥è¯å¥:
å½ä»¤è¡ä¸è¾å
¥ï¼
E:/oracle11g/app/oracle/product/11.2.0/server/bin/impdp "'/as sysdba'" DUMPFILE=20130620.dmp DIRECTORY=DATA_PUMP_DIR
è¾å
¥ç¨æ·åå¯ç 导å
¥å¼å§-----
ä½è¿è¡çæ¶åæ»æ¯æ示å°è¡¨ã
çº ç» å次å导åºå¯¼å
¥ æè
¾å¥½å 次.
è¿æ¯ä¸æ ·çç»æã
æå没åæ³äºæ¾åºä»¥åçå建表è¯å¥éæ°æ§è¡ï¼
æå好äºã
åå ï¼Oracle导åºæ¶åå¦æ表ä¸æ æ°æ®ï¼å°±ä¸å建表è¯å¥ã导è´è¿ä¸ªé®é¢ãã
è²ä¼¼Oracleå¯ä»¥è®¾ç½®è¿ä¸ªé®é¢ï¼ææ¶è¿æ²¡æç 究ã
温馨提示:答案为网友推荐,仅供参考