imp username/password@connect_string param=value â¦
exp username/password@connect_string param=value â¦
å¦ææ¯å¨sqlpluså½ä»¤ä¸ï¼è¦å¨impæè
expå½ä»¤åå $ï¼ä¸ç¶ä¼æ¥éï¼SP2-0734:æªç¥çå½ä»¤å¼å¤´ âexp pafirc â¦âï¼å¦ææ¯å¨cmdå½ä»¤çªå£ä¸ï¼å¦ææ¯ç¨sqlplus "ç¨æ·å/å¯ç "ç»éçï¼ç¸å½äºå¨sqlpluså½ä»¤çªå£ä¸ï¼ï¼åå¯ä»¥ä¸ç¨ã
æ°æ®å¯¼åºï¼
1 å°æ°æ®åºTESTå®å
¨å¯¼åº,ç¨æ·åsystem å¯ç manager 导åºå°D:\daochu.dmpä¸
exp system/manager@TEST file=d:\daochu.dmp full=y
2 å°æ°æ®åºä¸systemç¨æ·ä¸sysç¨æ·ç表导åº
exp system/manager@TEST file=d:\daochu.dmp owner=(system,sys)
3 å°æ°æ®åºä¸ç表inner_notifyãnotify_staff_relat导åº
exp aichannel/aichannel@TESTDB2 file= d:\data\newsmgnt.dmp tables=(inner_notify,notify_staff_relat)
4 å°æ°æ®åºä¸ç表table1ä¸çå段filed1以"00"æ头çæ°æ®å¯¼åº
exp system/manager@TEST file=d:\daochu.dmp tables=(table1) query=\" where filed1 like '00%'\"
ä¸é¢æ¯å¸¸ç¨ç导åºï¼å¯¹äºå缩ï¼æ¢ç¨winzipædmpæ件å¯ä»¥å¾å¥½çå缩ã
ä¹å¯ä»¥å¨ä¸é¢å½ä»¤åé¢ å ä¸ compress=y æ¥å®ç°ã
æ°æ®ç导å
¥:
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
ä¸é¢å¯è½æç¹é®é¢ï¼å 为æç表已ç»åå¨ï¼ç¶åå®å°±æ¥éï¼å¯¹è¯¥è¡¨å°±ä¸è¿è¡å¯¼å
¥ã
å¨åé¢å ä¸ ignore=y å°±å¯ä»¥äºã
2 å°d:\daochu.dmpä¸ç表table1 导å
¥
imp system/manager@TEST file=d:\daochu.dmp tables=(table1)
åºæ¬ä¸ä¸é¢ç导å
¥å¯¼åºå¤ç¨äºãä¸å°æ
åµè¦å
æ¯å°è¡¨å½»åºå é¤ï¼ç¶å导å
¥ã
注æï¼
æä½è
è¦æ足å¤çæéï¼æéä¸å¤å®ä¼æ示ã
æ°æ®åºæ¶å¯ä»¥è¿ä¸çãå¯ä»¥ç¨tnsping TEST æ¥è·å¾æ°æ®åºTESTè½å¦è¿ä¸ã
éå½ä¸ï¼
ç»ç¨æ·å¢å 导å
¥æ°æ®æéçæä½
第ä¸,å¯å¨sql*puls
第äºï¼ä»¥system/managerç»é
第ä¸ï¼create user ç¨æ·å IDENTIFIED BY å¯ç (å¦æå·²ç»å建è¿ç¨æ·ï¼è¿æ¥å¯ä»¥çç¥)
第åï¼GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,CONNECT,RESOURCE,CREATE SESSION TO ç¨æ·åå
第äº, è¿è¡-cmd-è¿å
¥dmpæ件æå¨çç®å½,
imp userid=system/manager full=y file=*.dmp
æè
imp userid=system/manager full=y file=filename.dmp
æ§è¡ç¤ºä¾:
F:\Work\Oracle_Data\backup>imp userid=test/test full=y file=inner_notify.dmp
å±å¹æ¾ç¤º
Import: Release 8.1.7.0.0 - Production on ææå 2æ 16 16:50:05 2006
(c) Copyright 2000 Oracle Corporation. All rights reserved.
è¿æ¥å°: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
ç»ç±å¸¸è§è·¯å¾å¯¼åºç±EXPORT:V08.01.07å建çæ件
å·²ç»å®æZHS16GBKå符éåZHS16GBK NCHAR å符éä¸ç导å
¥
导åºæå¡å¨ä½¿ç¨UTF8 NCHAR å符é (å¯è½çncharset转æ¢)
æ£å¨å°AICHANNELç对象导å
¥å° AICHANNEL
æ£å¨å¯¼å
¥è¡¨ "INNER_NOTIFY" 4è¡è¢«å¯¼å
¥
åå¤å¯ç¨çº¦ææ¡ä»¶...
æåç»æ¢å¯¼å
¥ï¼ä½åºç°è¦åã
éå½äºï¼
Oracle ä¸å
许ç´æ¥æ¹å表çæ¥æè
, å©ç¨Export/Importå¯ä»¥è¾¾å°è¿ä¸ç®ç.
å
建ç«import9.par,
ç¶åï¼ä½¿ç¨æ¶å½ä»¤å¦ä¸ï¼imp parfile=/filepath/import9.par
ä¾ import9.par å
容å¦ä¸ï¼
FROMUSER=TGPMS
TOUSER=TGPMS2 (注ï¼æ表çæ¥æè
ç±FROMUSERæ¹ä¸ºTOUSERï¼FROMUSER
TOUSERçç¨æ·å¯ä»¥ä¸å)
ROWS=Y
INDEXES=Y
GRANTS=Y
CONSTRAINTS=Y
BUFFER=409600
file==/backup/ctgpc_20030623.dmp
log==/backup/import_20030623.log
温馨提示:答案为网友推荐,仅供参考