对äºæ¬æºå®è£
äºoracle 客æ·ç«¯ï¼ä¸è¿°å½ä»¤é½å¯ä»¥å¨ dos æ§è¡ï¼å½ç¶ dmp æ件导åºå¨æ¬å°ã
ä½å¨å®é
ç åæ¶ï¼æ²¡äººæ¿æå¨æ¬æºä¸å®è£
åºå¤§ç oracle 软件ï¼è¿æ¶ä½ éè¦ä½¿ç¨ Xshell/puTTY..
è¿ç¨å·¥å
·è¿æ¥å° Linux è¿è¡æä½ï¼è¿è¡ Linux ä¸ dmp æ件ç导å
¥å¯¼åºã
a. å°ç¨æ· system ç¨æ·è¡¨å¯¼åºå°æå®è·¯å¾ D ç
exp system/password@SID file=d:/daochu.dmp full=y
b. å°ç¨æ· system ä¸ sys ç¨æ·ç表导åºå°æå®è·¯å¾ D ç
exp system/password@SID file=d:/daochu.dmp owner=(system,sys)
c. å°ç¨æ· system ä¸ç表 table_Aãtable_B 导åºå°æå®è·¯å¾ D ç
exp system/password@SID file= d:/daochu.dmp tables=(table_A,table_B)
d. å°ç¨æ· system ä¸ç表 table1 ä¸çå段 filed1 以"00"æ头çæ°æ®å¯¼åº
exp system/passwor@SID filed=d:/daochu.dmp tables=(table1) query=/" where filed1 like '00%'/"
对äºå缩å¯ä»¥ç¨ winzip å° dmp æ件è¿è¡å缩,ä¹å¯ä»¥å¨ä¸é¢å½ä»¤åé¢ å ä¸ compress=y æ¥å®ç°ã
å¯¼åº DMPæ件éç¨äºå¤§åæ°æ®åºå®æ´è¿ç§»ï¼å¯¹è¿ç§»åå两è
æå¡å¨æ°æ®åºå符éè¦æ±ä¸è´ï¼ä¸å¯¹CLOBå段æ¯æä¸å¤ªå好ã
对äºå°æ°æ®ç导åºå
¶å®ç¨ PLSQL è½åçæ´å¥½ï¼æ´å¿«ï¼å¯¼åºçSQLä¹å¾ç´è§ã
e. å° D:/daochu.dmp ä¸çæ°æ®å¯¼å
¥ TEST æ°æ®åºä¸ã
imp system/password@SID file=d:/daochu.dmp
imp system/password@HUST full=y file=d:/data/newsmgnt.dmp ignore=y
ä¸é¢å½ä»¤å¦æåºç°é®é¢ï¼å设æç表已åå¨ï¼å¯¹è¯¥è¡¨å¯ä»¥ä¸è¿è¡å¯¼å
¥ï¼åé¢æ·»å ignore=yã
f. å° d:/daochu.dmpä¸ç表table1 导å
¥
imp system/passord@SID file=d:/daochu.dmp tables=(table1)
温馨提示:答案为网友推荐,仅供参考