1 Linux Normal export/import
1.1 Export under Terminal
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 End of Import
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 Data pump export/import
2.1 SQL command mode , create directory "Sgtms" first
CREATE OR REPLACE DIRECTORY Sgtms as '/orabackup ';
2.2 Export under terminal (two ways)
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 Terminal under import (two ways)
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 Normal mode export/import
3.1 cmd console export
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 console under import
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 Data Pump export/import
4.1 SQL command mode , create directory "sgtms" first
CREATE OR REPLACE DIRECTORY Sgtms as ' E:\BackupSGTMS ';
4.2 cmd Console export
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 console under Import
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 database common/Data pump mode import/output example in Windows/linux environment