å ³äºdmpæ件æ们ç¨çè¿æ¯æ¯è¾å¤çï¼dmpæ件å®æ¯ä½ä¸ºoracleå¯¼å ¥å导åºè¡¨ä½¿ç¨çæä»¶æ ¼å¼ï¼ä»å¤©å°±å°dmpæ件导åºåå¯¼å ¥è¿è¡å¦ä¹ ã
dmpæ件导åº
dmpæ件导åºç¨çæ¯è¾å¤çä¸è¬æ¯ä¸ç§ï¼ä»ä»¬åå«æ¯ï¼å¯¼åºæ´ä¸ªæ°æ®åºå®ä¾ä¸çæææ°æ®ã导åºæå®ç¨æ·çææ表ã导åºæå®è¡¨ã
è¿éå·²æçæ°æ®åºä¸ºä¾ï¼è¿è¡ä»ç»ï¼æçOracleæ°æ®åºå®ä¾ä¸º"ORACLE",æ¥çèªå·±æ°æ®åºå®ä¾å¯ä»¥ä»"ä»»å¡ç®¡çå¨-->æå¡"ä¸è¿è¡æ¥çï¼å¦ä¸å¾
æå¼å½ä»¤è¡ï¼
1ï¼å°æ°æ®åºORACLEå®å ¨å¯¼åº,ç¨æ·åsystemå¯ç manager 导åºå°c:\daochu.dmpä¸
exp system/manager@ORACLE file=c:\daochu.dmp full=y
2ï¼å°æ°æ®åºä¸RFDç¨æ·ä¸,JYZGCXç¨æ·ç表导åº
exp system/manager@ORACLE file=d:\daochu.dmpowner=(RFD,JYZGCX)
3ï¼å°æ°æ®åºä¸ç表T_USERãT_ROLE导åº
expJYZGCX/JYZGCX@ORACLEfile= d:\data\newsmgnt.dmp tables=(T_USER,T_ROLE)
ä¸é¢çsystem为ç¨æ·åï¼manager为å¯ç ï¼ORACLE为æ°æ®åºå®ä¾åï¼å ¶å®ä¸ä¸å®éçç¨systemç¨æ·ï¼åªè¦æ¯æ¥æ管çåæéçç¨æ·é½å¯ä»¥ã
dmpæä»¶å¯¼å ¥
1ï¼æå¼âå¼å§â-->è¾å ¥cmdâ> sqlplus /nologï¼
2ï¼è¾å ¥ conn / as sysdba管çåè´¦æ·ç»å½ï¼
3ï¼éè¦å建表空é´ï¼å¦ææ们ç¥ééè¦å¯¼å ¥çæ°æ®åºç表空é´ç´æ¥å建就å¯ä»¥ï¼å¦æä¸ä¸ç¥éï¼ä¹æ²¡æå ³ç³»ï¼æ们å¯ä»¥ç¨txtæå¼dmpæ件ï¼ä½¿ç¨å¿«æ·é®ctrl+Fï¼æ¥æ¾tablespaceï¼å°±å¯ä»¥æ¾å°è¿ä¸ªdmpæ件æ对åºæ°æ®åºç表空é´ï¼ç¶åå建æ们æ¾å°ç表空é´å°±å¯ä»¥ï¼
æ¥ï¼ä¸å建ç表空é´ï¼å建ç¨æ·ï¼å¹¶åé æéï¼
5ï¼æå¼âå¼å§â-->è¾å ¥cmd(注æï¼è¿éæ¯cmdçªå£ï¼ä¸æ¯sqlplusçªå£ï¼ï¼ï¼)ï¼è¾å ¥ä»¥ä¸è¯å¥ï¼âimp kang/123456@localhost/ORACLEfile="C:\daochu.dmp"full=y ignore=yâ
ä¸è¿°è¯å¥è¯´æå¦ä¸:
kangæ¯å建çç»å½æ°æ®åºç¨æ·åï¼
123456æ¯ç»å½æ°æ®åºçå¯ç ï¼
localhostï¼ä»£è¡¨å½åæ°æ®åºçå°åæ¯æ¬æºï¼å¦ææ¯è¿ç¨å¯¼å ¥ï¼æ¿æ¢æ对åºçipå°åå°±è¡
ORACLEï¼æ¯å®ä¾å称)
fileï¼åé¢çæ¯ä½ å½ådmpæ件åæ¾çè·¯å¾
full=yï¼è¿ä¸ªè²ä¼¼æ¯å ¨é¨
ignore=yï¼å¿½ç¥ä¸äºé误