1 Linux普通导出/入
1.1 终端下导出
exp user/pwd@192.168.100.100/dbPro owner='('mm_app,mm_sys')' file=/orabackup/db_201408131200.dmp log= /orabackup/db_201408131200.Log buffer=80000000
1.2 终端下导入
imp user/pwd@dbPro fromuser=(mm_app,mm_sys) touser=(mm_app,mm_sys) file=D:\dbPro\init\dbPro_201408131105.dmp log=D:\dbPro\init\dbPro_201408131105.Log
2 Linux数据泵导出/入
2.1 SQL命令模式下先创建目录“dbPro”
CREATE OR REPLACE DIRECTORY dbPro AS '/orabackup';
2.2 终端下导出（两种方式）
expdp user/pwd@192.168.100.100/dbPro directory=dbPro dumpfile=dbPro_expdp_201408131200-%U.dmp parallel=4 schemas=mm_app,mm_sys logfile=dbPro_expdp_201408131200.log
expdp user/pwd@192.168.100.100/dbPro directory=dbPro parallel=1 schemas=mm_app,mm_sys dumpfile=dbPro_expdp_201408131200.dmp logfile=dbPro_expdp_201408131200.log
2.3 终端下导入（两种方式）
impdp user/pwd@dbPro directory=dbPro dumpfile=dbPro_expdp_%U.dmp parallel=4 schemas=mm_app,mm_sys logfile=imp_dbPro_expdp.log
impdp user/pwd@dbPro directory=dbPro dumpfile=dbPro_expdp_201408261630.dmp parallel=1 schemas=mm_app,mm_sys logfile=imp_dbPro_expdp.log
3 Windows普通模式导出/入
3.1 CMD控制台下导出
exp user/pwd@dbPro owner=(mw_app,mw_sys,statdba,dictdba) file=D:\dbPro_20140523.dmp log= D:\dbPro_20140523.Log buffer=80000000
3.2 CMD控制台下导入
imp user/pwd@dbPro file=D:\dbPro\init\dbPro_20140523172007.dmp fromuser=(mw_sys,mw_app,statdba,dictdba) touser=(mw_sys,mw_app,statdba,dictdba) log=D:\dbPro\init\dbPro_20140523172007.log
4 Windows数据泵导出/入
4.1 SQL命令模式下先创建目录“dbPro”
CREATE OR REPLACE DIRECTORY dbPro AS 'E:\BackupdbPro';
4.2 CMD控制台下导出
expdp system/system@dbPro directory=dbPro dumpfile=dbPro_expdp_201408141145.dmp parallel=1 schemas=mm_app,mm_sys logfile=dbPro_expdp_201408141145.log
4.3 CMD控制台下导入
impdp user/pwd@dbPro directory=dbPro dumpfile=dbPro_expdp_%U.dmp parallel=4 schemas=mm_app,mm_sys logfile=imp_dbPro_expdp.log
1 Linux普通导出/入
1.1 终端下导出
exp user/pwd@192.168.100.100/dbPro owner='('mm_app,mm_sys')' file=/orabackup/db_201408131200.dmp log= /orabackup/db_201408131200.Log buffer=80000000
1.2 终端下导入
imp user/pwd@dbPro fromuser=(mm_app,mm_sys) touser=(mm_app,mm_sys) file=D:\dbPro\init\dbPro_201408131105.dmp log=D:\dbPro\init\dbPro_201408131105.Log
2 Linux数据泵导出/入
2.1 SQL命令模式下先创建目录“dbPro”
CREATE OR REPLACE DIRECTORY dbPro AS '/orabackup';
2.2 终端下导出（两种方式）
expdp user/pwd@192.168.100.100/dbPro directory=dbPro dumpfile=dbPro_expdp_201408131200-%U.dmp parallel=4 schemas=mm_app,mm_sys logfile=dbPro_expdp_201408131200.log
expdp user/pwd@192.168.100.100/dbPro directory=dbPro parallel=1 schemas=mm_app,mm_sys dumpfile=dbPro_expdp_201408131200.dmp logfile=dbPro_expdp_201408131200.log
2.3 终端下导入（两种方式）
impdp user/pwd@dbPro directory=dbPro dumpfile=dbPro_expdp_%U.dmp parallel=4 schemas=mm_app,mm_sys logfile=imp_dbPro_expdp.log
impdp user/pwd@dbPro directory=dbPro dumpfile=dbPro_expdp_201408261630.dmp parallel=1 schemas=mm_app,mm_sys logfile=imp_dbPro_expdp.log
3 Windows普通模式导出/入
3.1 CMD控制台下导出
exp user/pwd@dbPro owner=(mw_app,mw_sys,statdba,dictdba) file=D:\dbPro_20140523.dmp log= D:\dbPro_20140523.Log buffer=80000000
3.2 CMD控制台下导入
imp user/pwd@dbPro file=D:\dbPro\init\dbPro_20140523172007.dmp fromuser=(mw_sys,mw_app,statdba,dictdba) touser=(mw_sys,mw_app,statdba,dictdba) log=D:\dbPro\init\dbPro_20140523172007.log
4 Windows数据泵导出/入
4.1 SQL命令模式下先创建目录“dbPro”
CREATE OR REPLACE DIRECTORY dbPro AS 'E:\BackupdbPro';
4.2 CMD控制台下导出
expdp system/system@dbPro directory=dbPro dumpfile=dbPro_expdp_201408141145.dmp parallel=1 schemas=mm_app,mm_sys logfile=dbPro_expdp_201408141145.log
4.3 CMD控制台下导入
impdp user/pwd@dbPro directory=dbPro dumpfile=dbPro_expdp_%U.dmp parallel=4 schemas=mm_app,mm_sys logfile=imp_dbPro_expdp.log