Example of importing and exporting Common Data Pump in Windows Linux
Examples of importing and exporting Oracle databases in normal/Data Pump Mode in Windows/Linux Environments
Examples of importing and exporting Oracle databases in normal/Data Pump Mode in Windows/Linux Environments
1 Linux normal export/import
1.1 terminal Export
Exp naricom/[email protected]/SGTMS owner = '('MW _ app, mw_sys, statdba, dictdba ') 'file =/orabackup/sgtms_201408316200.dmp log =/orabackup/sgtms_201408316200.log 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.1 create the directory "sgtms" in SQL command mode"
Create or replace directory sgtms AS '/orabackup ';
2.2 terminal Export (two methods)
Expdp naricom/[email protected]/SGTMS directory = sgtms dumpfile = sgtms_expdp_201408131200-% U. dmp parallel = 4 schemas = DICTDBA, MW_APP, MW_SYS, STATDBA logfile = Taobao
Expdp naricom/[email protected]/SGTMS directory = sgtms parallel = 1 schemas = DICTDBA, MW_APP, MW_SYS, STATDBA dumpfile = sgtms_expdp_201408425200.dmp logfile = Taobao
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.1 create the directory "sgtms" in SQL command mode"
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
This article permanently updates the link address:
,