Oracleä¸å¯¼å
¥dmpæ件çæ¥éª¤å¦ä¸:
ãã1 å°D:\daochu.dmp ä¸çæ°æ®å¯¼å
¥ TESTæ°æ®åºä¸ã
imp system/manager@TEST file=d:\daochu.dmp
ãã imp aichannel/aichannel@HUST full=y file=file= d:\data\newsmgnt.dmp ignore=y
ãã2 å°d:\daochu.dmpä¸ç表table1 导å
¥:
ããimp system/manager@TEST file=d:\daochu.dmp tables=(table1)
ããåºæ¬ä¸ä¸é¢ç导å
¥å¯¼åºå¤ç¨äºãä¸å°æ
åµè¦å
æ¯å°è¡¨å½»åºå é¤ï¼ç¶å导å
¥ã
ãã注æï¼æä½è
è¦æ足å¤çæéï¼æéä¸å¤å®ä¼æ示ãæ°æ®åºæ¶å¯ä»¥è¿ä¸çãå¯ä»¥ç¨tnsping TEST æ¥è·å¾æ°æ®åºTESTè½å¦è¿ä¸ã
温馨提示:答案为网友推荐,仅供参考