æ¨å¥½ï¼å¾é«å
´ä¸ºæ¨è§£çã
oracle10g æ°æ®å¯¼å
¥å°oracle11g ä¸ï¼
å¨oracle10g ä¸æ§è¡:Exp ts/ts@orcl file=D:\tianshan.dmp
å¨oracle11g ä¸å建好表空é´åç¨æ·åæ§è¡ï¼Imp ts/ts@orcl file=D:\tianshan.dmp
Oracle11g æ°æ®å¯¼å
¥å°oracle10g ä¸ï¼
1.å¨oracle11g æå¡å¨å½ä»¤è¡ä¸ç¨expdp 导åºæ°æ®
expdp ts/ts@orcl directory=expdp_dir dumpfile=tianshan.dmp logfile=tianshan.log version=10.2.0.1.0 (schemas=ccense)
2.å¨oracle10g æå¡å¨DOS å½ä»¤è¡ä¸ç¨IMPDP 导å
¥æ°æ®ï¼
æoracle11g çå¤ä»½æ件æ¾å°oracl10g æå¡å¨çimpdp_dir ç®å½ä¸ï¼å¹¶å建好ç¸åºçç¨æ·å表空é´ï¼ç¶åæ§è¡ä¸é¢çå½ä»¤ï¼
impdp ts/ts@orcl directory=impdp_dir dumpfile=tianshan.dmp logfile=tianshan.log version=10.2.0.1.0 (schemas=ccense)
Oracle çimp/exp ç»ä»¶çä¸ä¸ªæä½ååå°±æ¯åä¸å
¼å®¹ï¼ä¸æä¸äºè§åï¼
1ãä½çæ¬çexp/imp å¯ä»¥è¿æ¥å°é«çæ¬ï¼æåçæ¬ï¼çæ°æ®åºæå¡å¨ï¼ä½é«çæ¬çexp/imp ä¸è½è¿æ¥å°ä½çæ¬çæ°æ®åºæå¡å¨ã
2ãé«çæ¬exp åºçdmp æ件ï¼ä½çæ¬æ æ³impï¼æ æ³è¯å«dmp æ件ï¼ï¼ä½çæ¬exp åºçdmp æ件ï¼é«çæ¬å¯ä»¥impï¼åä¸å
¼å®¹ï¼ã
3ãä»Oracle ä½çæ¬Export çæ°æ®å¯ä»¥Import å°Oracle é«çæ¬ä¸ï¼ä½éäºOracle çç¸é»çæ¬ï¼å¦ä»Oracle 7 å° Oracle 8ã对äºä¸¤ä¸ªä¸ç¸é»çæ¬é´è¿è¡è½¬æ¢ï¼å¦ä»Oracle 6 å° Oracle 8ï¼ååºå
å°æ°æ®è¾å
¥å°ä¸é´çæ¬âOracle 7ï¼åä»ä¸é´æ°æ®åºè½¬å
¥æ´é«çæ¬Oracle8
温馨提示:答案为网友推荐,仅供参考