標籤：oracle expdp impdp 資料泵
1 Linux普通匯出/入
1.1 終端下匯出
exp naricom/[email protected]/SGTMS owner=‘(‘mw_app,mw_sys,statdba,dictdba‘)‘ file=/orabackup/SGTMS_201408131200.dmp log= /orabackup/SGTMS_201408131200.Log buffer=80000000
1.2 終端下匯入
imp naricom/[email protected] fromuser=(MW_SYS,MW_APP,STATDBA,DICTDBA) touser=(MW_SYS,MW_APP,STATDBA,DICTDBA) file=D:\SGTMSDB\init\SGTMS_201408131105.dmp log=D:\SGTMSDB\init\SGTMS_201408131105.Log
2 Linux資料泵匯出/入
2.1 SQL命令模式下先建立目錄“sgtms”
CREATE OR REPLACE DIRECTORY sgtms AS ‘/orabackup‘;
2.2 終端下匯出（兩種方式）
expdp naricom/[email protected]/SGTMS directory=sgtms dumpfile=sgtms_expdp_201408131200-%U.dmp parallel=4 schemas=DICTDBA,MW_APP,MW_SYS,STATDBA logfile=sgtms_expdp_201408131200.log
expdp naricom/[email protected]/SGTMS directory=sgtms parallel=1 schemas=DICTDBA,MW_APP,MW_SYS,STATDBA dumpfile=sgtms_expdp_201408131200.dmp logfile=sgtms_expdp_201408131200.log
2.3 終端下匯入（兩種方式）
impdp naricom/[email protected] directory=sgtms dumpfile=sgtms_expdp_%U.dmp parallel=4 schemas=DICTDBA,MW_APP,MW_SYS,STATDBA logfile=imp_sgtms_expdp.log
impdp naricom/[email protected] directory=sgtms dumpfile=sgtms_expdp_201408261630.dmp parallel=1 schemas=DICTDBA,MW_APP,MW_SYS,STATDBA logfile=imp_sgtms_expdp.log
3 Windows普通模式匯出/入
3.1 CMD控制台下匯出
exp naricom/[email protected] owner=(mw_app,mw_sys,statdba,dictdba) file=D:\SGTMS_20140523.dmp log= D:\SGTMS_20140523.Log buffer=80000000
3.2 CMD控制台下匯入
imp naricom/[email protected] file=D:\SGTMSDB\init\SGTMS_20140523172007.dmp fromuser=(mw_sys,mw_app,statdba,dictdba) touser=(mw_sys,mw_app,statdba,dictdba) log=D:\SGTMSDB\init\SGTMS_20140523172007.log
4 Windows資料泵匯出/入
4.1 SQL命令模式下先建立目錄“sgtms”
CREATE OR REPLACE DIRECTORY sgtms AS ‘E:\BackupSGTMS‘;
4.2 CMD控制台下匯出
expdp system/[email protected] directory=sgtms dumpfile=sgtms_expdp_201408141145.dmp parallel=1 schemas=DICTDBA,MW_APP,MW_SYS,STATDBA logfile=sgtms_expdp_201408141145.log
4.3 CMD控制台下匯入
impdp naricom/[email protected] directory=sgtms dumpfile=sgtms_expdp_%U.dmp parallel=4 schemas=DICTDBA,MW_APP,MW_SYS,STATDBA logfile=imp_sgtms_expdp.log
Oracle資料庫分別在Windows/Linux環境下普通/資料泵方式匯入/匯出樣本
