ITPub博客

首页 > Linux操作系统 > Linux操作系统 > exp&expdb example

exp&expdb example

原创 Linux操作系统 作者:golden_zhou 时间:2011-03-10 10:12:18 0 删除 编辑

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8


export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
expdp system/'system' directory=EXPDP_DUMP_DIR dumpfile=dfms20110225.dmp schemas=dfms logfile=dfms20110225.log
impdp system/'system'@dell10qc directory=EXPDP_DUMP_DIR dumpfile=dfms20110225.dmp schemas=dfms logfile=dfms20110225.log remap_schema=dfms:dfms


exp sys/"sys$test"@delll6 as sysdba wner=ipciqa file=delll6.dmp log=l6.log rows=n
exp sys/"sys$test"@delll10 as sysdba wner=delliqa file=delll6.dmp log=l6.log

exp xxxx/xxxx@umlaut tables=R_WIP_LOG_T file=R_WIP_LOG_T.dmp log=R_WIP_LOG_T.log feedback=10000000
imp xxxx/xxxx@umlaut tables=R_WIP_LOG_T file=R_WIP_LOG_T.dmp log=R_WIP_LOG_T.log fromuser=sfism4 touser=sfism4 ignore=y commit=y feedback=1000000

 

set NLS_LANG=AMERICAN_AMERICA.AL32UTF8

exp sfis1/xxx@mis wner=sfis1 file=e:\temp\sfis1.dmp log=e:\temp\sfis1.log

imp sfis1/xxx@mis file=sfis1.dmp log=sfis1.log fromuser=sfis1 touser=sfis1 ignore=y


exp ajin/xxx@mmis wner=fmis file=d:\temp\fmis.dmp log=d:\temp\fmis.log rows=n

exp ajin/xxx@mmis wner=mmis file=d:\temp\mmis.dmp log=d:\temp\mmis.log

 

imp ajin/xxx@mmis file=fmis.dmp log=fmis.log fromuser=fmis touser=fmis ignore=y

/u01/product/oracle/bin/expdp system/system"$"oracle directory=dump dumpfile=$ORACLE_SID$FILENAME.dmp full=y logfile=$ORACLE_SID$FILENAME.log

impdp user/pwd directory=dump_dir dumpfile=mmis.dmp schemas=mmis logfile=mmis.log


export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
expdp admin/xxxx"$"dba directory=dump_dir dumpfile=full.dmp full=y logfile=full.log
expdp system/xxxx"$"oracle directory=dump dumpfile=WIP_S_PARTS_MASTER.dmp tables=DFMS.WIP_S_PARTS_MASTER logfile=WIP_S_PARTS_MASTER.log
impdp system/xxxxx"$"test directory=dump dumpfile=WIP_S_PARTS_MASTER.dmp tables=DFMS.WIP_S_PARTS_MASTER logfile=WIP_S_PARTS_MASTER.log table_exists_action=append

set NLS_LANG=AMERICAN_AMERICA.AL32UTF8
impdp user/pwd directory=dump_dir dumpfile=full.dmp schemas=mmis logfile=mmis.log
or
impdp user/pwd directory=dump_dir dumpfile=full.dmp schemas=fmis logfile=fmis.log

impdp 'system/"xxxxxxx"' directory=dump_dir dumpfile=full_20110107.dmp schemas=fmis,mmis,aqms,pqms,mould,foxydms logfile=fmis_20110107.log


expdp system/xxxxx"$"oracle directory=EXPDP_DUMP_DIR dumpfile=dfms1025.dmp schemas=dfms logfile=dfms1025.log
impdp system/xxxx"$"test directory=EXPDP_DUMP_DIR dumpfile=dfms1025.dmp schemas=dfms logfile=dfms1025.log

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
expdp sfism4/xxxx directory=EXPDP_DUMP_DIR dumpfile=R_WIP_LOG_T.dmp tables=R_WIP_LOG_T logfile=R_WIP_LOG_T.log
impdp sfism4/xxx directory=EXPDP_DUMP_DIR dumpfile=R_WIP_LOG_T.dmp tables=R_WIP_LOG_T logfile=R_WIP_LOG_T.log


export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
expdp system/xxxx$oracle' directory=EXPDP_DUMP_DIR dumpfile=dfms.dmp schemas=dfms logfile=dfms.log
expdp system/xxxx$oracle' directory=EXPDP_DUMP_DIR dumpfile=delliqa.dmp schemas=delliqa logfile=delliqa.log

impdp system/xxxx@dell10qc directory=EXPDP_DUMP_DIR dumpfile=dfms.dmp schemas=dfms logfile=dfms.log remap_schema=dfms:dfms
impdp system/xxxxx@dell10qc directory=EXPDP_DUMP_DIR dumpfile=delliqa.dmp schemas=delliqa logfile=delliqa.log

 

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
expdp system/"xxxxxxxxx" directory=dump_dir dumpfile=wm_wms_1230.dmp schemas=wm_wms logfile=wm_wms_1230.log
impdp system/"xxxxxxx" directory=dump_dir dumpfile=wm_wms_1230.dmp schemas=wm_wms logfile=wm_wms_1230.log remap_schema=wm_wms:wms_dev

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
expdp wms_dev/"xxxx" directory=dump_dir dumpfile=wms_dev_1230.dmp schemas=wms_dev logfile=wms_dev_1230.log
impdp wms_dev/"xxxx" directory=dump_dir dumpfile=wms_dev_1230.dmp schemas=wms_dev logfile=wms_dev_1230.log remap_schema=wms_dev:wms_dev

 

impdp sfism4/xxx directory=EXPDP_DUMP_DIR dumpfile=R_WIP_LOG_T.dmp tables=R_WIP_LOG_T logfile=R_WIP_LOG_T.log

 


exp esd_admin/xxxx tables=EN_NUMBER file=en_number.dmp log=en_number.log

imp esd/"xxxxxx" tables=EN_NUMBER file=en_number.dmp log=en_number.log fromuser=esd_admin touser=esd ignore=y


D:\backup>imp dt2global/"xxxxx" file=dt2global.DMP log=dt2global.log fromuser=dt2global touser=dt2global ignore=y


expdp system/xxxx directory=DUMP dumpfile=threetables.dmp tables=dfms.B2B_D_ASN_CSN,dfms.B2B_D_ASN_CTN,dfms.B2B_D_ASN_SSN logfile=threetables.log

impdp system/xxxx"$"oracle directory=DUMP dumpfile=threetables.dmp logfile=threetables.log remap_schema=dfms:dfms table_exists_action=truncate


expdp system/xxxx"$"xxxx directory=EXPDP_DUMP_DIR dumpfile=SYS_D_ERROR_TRACE.dmp tables=DFMS.SYS_D_ERROR_TRACE logfile=SYS_D_ERROR_TRACE.log

impdp system/"xxxxx" directory=dump_dir dumpfile=full.dmp schemas=aqms,fmis,mmis,pqms,mould,foxydms logfile=full.log content=metadata_only table_exists_action=skip
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
expdp system/system"$"oracle directory=DUMP_DIR dumpfile=DT2WIP.dmp schemas=dt2wip,dt2wip_ap logfile=DT2WIP.log
set NLS_LANG=AMERICAN_AMERICA.AL32UTF8
impdp system/xxxx directory=DUMP_DIR dumpfile=DT2WIP.dmp schemas=dt2wip,dt2wip_ap logfile=DT2WIP.log


impdp system/"xxxxx" directory=dump_dir dumpfile=full.dmp schemas=aqms logfile=aqms.log content=all table_exists_action=truncate

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25198367/viewspace-688897/,如需转载,请注明出处,否则将追究法律责任。

下一篇: flashback
请登录后发表评论 登录
全部评论

注册时间:2011-03-09

  • 博文量
    238
  • 访问量
    300916