å¨æå¡å¨Aä¸çå¼å§èåçCMD模å¼ä¸æ§è¡ å
¶ä¸cwgl/password æ¯æå¡å¨Aæ°æ®åºç»éçç¨æ·ååå¯ç ï¼serverAipæ¯æå¡å¨AçIPå°å exp cwgl/password@serverAip file=D:\backup.dmp full=y
å¨æå¡å¨Bä¸çå¼å§èåçCMD模å¼ä¸æ§è¡ å
¶ä¸cwgl/password æ¯æå¡å¨Bæ°æ®åºç»éçç¨æ·ååå¯ç ï¼serverBipæ¯æå¡å¨BçIPå°å,
imp cwgl/password@serverBip file=D:\backup.dmp full=y
éè¦æ³¨æçæ¯æå¡å¨AåBé½æ¯ORACLE11Gï¼èä¸ï¼æå¡å¨B导å
¥ä¹åè¦å»ºè¡¨ç©ºé´ï¼ç¨æ·åæéç
追é®å¨serverAç¨exp导åºåï¼ç¨Imp导å
¥å°serverBä¸çæ¶åï¼æå¾å¤ç空表导å
¥ä¸äºã
追çä½ çææå°±æ¯ç©ºè¡¨æ¥éäºï¼å
让æ°æ®å¯¼å®ãå 为åç»ä½ çè¯å¥æ²¡æå ignore=y忽ç¥é误å³ï¼imp cwgl/password@serverBip file=D:\backup.dmp full=y ignore=yã