2 Linux数据泵导出/入
2.1 SQL命令模式下先创建目录“sgtms”
3 Windows普通模式导出/入
3.1 CMD控制台下导出
exp naricom/naricom@SGTMS owner=(mw_app,mw_sys,statdba,dictdba) file=D:\SGTMS_20140523.dmp log= D:\SGTMS_20140523.Log? buffer=80000000
3.2 CMD控制台下导入
imp naricom/naricom@sgtms 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/system@SGTMS 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/naricom@SGTMS directory=sgtms dumpfile=sgtms_expdp_%U.dmp parallel=4 schemas=DICTDBA,MW_APP,MW_SYS,STATDBA? logfile=imp_sgtms_expdp.log