Examples of importing and exporting Oracle databases in common/Data Pump Mode in Windows/Linux environments, oraclelinux
1 Linux normal export/import
1.1 terminal Export
Exp naricom/naricom@10.185.3.100/SGTMS owner = '('MW _ app, mw_sys, statdba, dictdba') 'file =/orabackup/sgtms_201408379200.dmp log =/orabackup/limit buffer = 80000000
1.2 terminal Import
Imp naricom/naricom @ SGTMS 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.1In SQL command modeFirst create the directory "sgtms"
Create or replace directory sgtms AS '/orabackup ';
2.2 terminal Export (two methods)
Expdp naricom/naricom@10.185.3.100/SGTMS directory = sgtms dumpfile = sgtms_expdp_201408131200-% U. dmp parallel = 4 schemas = DICTDBA, MW_APP, MW_SYS, STATDBA logfile = Login
Expdp naricom/naricom@10.185.3.100/SGTMS directory = sgtms parallel = 1 schemas = DICTDBA, MW_APP, MW_SYS, STATDBA dumpfile = sgtms_expdp_201408425200.dmp logfile = bytes
2.3 terminal import (two methods)
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
Impdp naricom/naricom @ SGTMS directory = sgtms dumpfile = sgtms_expdp_201408261630.dmp parallel = 1 schemas = DICTDBA, MW_APP, MW_SYS, STATDBA logfile = imp_sgtms_expdp.log
3 Export/Import in Windows Normal Mode
3.1 export in the cmd Console
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 import in CMD Console
Imp naricom/naricom @ sgtms file = D: \ SGTMSDB \ init \ export 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.1In SQL command modeFirst create a directory"Sgtms"
Create or replace directory sgtms AS 'e: \ BackupSGTMS ';
4.2 export in the cmd Console
Expdp system/system @ SGTMS directory = sgtms dumpfile = sgtms_expdp_201408141145.dmp parallel = 1 schemas = DICTDBA, MW_APP, MW_SYS, STATDBA logfile = callback
4.3 import in CMD Console
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