ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 常用導出導入腳本

常用導出導入腳本

原创 Linux操作系统 作者:golden_zhou 时间:2011-08-30 17:19:32 0 删除 编辑

select 'exec dbms_stats.unlock_table_stats(ownname =>'''||owner||''',tabname =>'''||table_name||''''||') ;' from dba_tables where wner='SFISM4'

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

expdp 'system/"system#test"' directory=dump_dir dumpfile=full_umlaut20110428.dmp full=y logfile=full_umlaut20110428.log

impdp 'system/"system$oracle"'@umlaut directory=dump_dir dumpfile=full_umlaut20110428.dmp log=sfis20110428.log schemas=sfis remap_schema=sfis:sfis  table_exists_action=truncate

impdp 'system/"system$oracle"'@umlaut directory=dump_dir dumpfile=full_umlaut20110428.dmp log=sfis120110428.log schemas=sfis1 remap_schema=sfis1:sfis1 table_exists_action=truncate

impdp 'system/"system$oracle"'@umlaut directory=dump_dir dumpfile=full_umlaut20110428.dmp log=sfism420110428.log schemas=sfism4 remap_schema=sfism4:sfism4 table_exists_action=truncate

impdp 'system/"system$oracle"'@umlaut directory=dump_dir dumpfile=full_umlaut20110428.dmp log=mweb20110428.log schemas=mweb remap_schema=mweb:mweb table_exists_action=truncate

impdp 'system/"system$oracle"'@umlaut directory=dump_dir dumpfile=full_umlaut20110428.dmp log=macadmin20110428.log schemas=macadmin remap_schema=macadmin:macadmin table_exists_action=truncate

 

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
expdp 'system/"system#test"' directory=dump_dir dumpfile=full_acer20110429.dmp full=y logfile=full_acer20110429.log


impdp 'system/"system$oracle"'@dt2acer directory=dump_dir dumpfile=full_acer20110429.dmp log=sfis120110429.log schemas=sfis1 remap_schema=sfis1:sfis1 table_exists_action=truncate

impdp 'system/"system$oracle"'@dt2acer directory=dump_dir dumpfile=full_acer20110429.dmp log=sfism420110429.log schemas=sfism4 remap_schema=sfism4:sfism4 table_exists_action=truncate

impdp 'system/"system$oracle"'@dt2acer directory=dump_dir dumpfile=full_acer20110429.dmp log=mweb20110429.log schemas=mweb remap_schema=mweb:mweb table_exists_action=truncate

impdp 'system/"system$oracle"'@dt2acer directory=dump_dir dumpfile=full_acer20110429.dmp log=macadmin20110429.log schemas=macadmin remap_schema=macadmin:macadmin table_exists_action=truncate


export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
expdp 'system/"system#test"' directory=dump_dir dumpfile=full_mmis20110429.dmp full=y logfile=full_mmis20110429.log


impdp 'system/"system$oracle"'@mmis directory=dump_dir dumpfile=full_mmis20110429.dmp log=emrs20110429.log schemas=emrs remap_schema=emrs:emrs table_exists_action=truncate

impdp 'system/"system$oracle"'@mmis directory=dump_dir dumpfile=full_mmis20110429.dmp log=mmis20110429.log schemas=mmis remap_schema=mmis:mmistable_exists_action=truncate

impdp 'system/"system$oracle"'@mmis directory=dump_dir dumpfile=full_mmis20110429.dmp log=mms20110429.log schemas=mms remap_schema=mms:mms table_exists_action=truncate

impdp 'system/"system$oracle"'@mmis directory=dump_dir dumpfile=full_mmis20110429.dmp log=mould20110429.log schemas=mould remap_schema=mould:mould table_exists_action=truncate

impdp 'system/"system$oracle"'@mmis directory=dump_dir dumpfile=full_mmis20110429.dmp log=pdms20110429.log schemas=pdms remap_schema=pdms:pdms table_exists_action=truncate


export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
expdp 'system/"system#test"' directory=dump_dir dumpfile=full_orcl20110504.dmp full=y logfile=full_orcl20110504.log


impdp 'system/"system$oracle"'@orcl directory=dump_dir dumpfile=full_orcl20110504.dmp log=sfis120110504.log schemas=sfis1 remap_schema=sfis1:sfis1 table_exists_action=truncate

impdp 'system/"system$oracle"'@orcl directory=dump_dir dumpfile=full_orcl20110504.dmp log=sfism420110504.log schemas=sfism4 remap_schema=sfism4:sfism4 table_exists_action=truncate

impdp 'system/"system$oracle"'@orcl directory=dump_dir dumpfile=full_orcl20110504.dmp log=mweb20110504.log schemas=mweb remap_schema=mweb:mweb table_exists_action=truncate

impdp 'system/"system$oracle"'@orcl directory=dump_dir dumpfile=full_orcl20110504.dmp log=macadmin20110504.log schemas=macadmin remap_schema=macadmin:macadmin table_exists_action=truncate


impdp 'system/"system$oracle"'@orcl directory=dump_dir dumpfile=full_orcl20110504.dmp log=dfms20110504.log schemas=dfms remap_schema=dfms:dfms table_exists_action=truncate

 

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
expdp 'system/"system#test"' directory=dump_dir dumpfile=full_emd2rc20110505.dmp full=y logfile=full_emd2rc20110505.log


impdp 'system/"system$oracle"'@dmd1rc directory=dump_dir dumpfile=full_emd2rc20110505.dmp log=sfis120110505.log schemas=sfis1 remap_schema=sfis1:sfis1 table_exists_action=truncate

impdp 'system/"system$oracle"'@dmd1rc directory=dump_dir dumpfile=full_emd2rc20110505.dmp log=sfism420110505.log schemas=sfism4 remap_schema=sfism4:sfism4 table_exists_action=truncate

impdp 'system/"system$oracle"'@dmd1rc directory=dump_dir dumpfile=full_emd2rc20110505.dmp log=mweb20110505.log schemas=mweb remap_schema=mweb:mweb table_exists_action=truncate

impdp 'system/"system$oracle"'@dmd1rc directory=dump_dir dumpfile=full_emd2rc20110505.dmp log=ict20110505.log schemas=ict remap_schema=ict:ict table_exists_action=truncate

 

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
expdp 'system/"system#test"' directory=dump_dir dumpfile=full_whrma20110505.dmp full=y logfile=full_whrma20110505.log


impdp 'system/"system$oracle"'@whrma directory=dump_dir dumpfile=full_whrma20110505.dmp log=sfis120110505.log schemas=sfis1 remap_schema=sfis1:sfis1 table_exists_action=truncate

impdp 'system/"system$oracle"'@whrma directory=dump_dir dumpfile=full_whrma20110505.dmp log=sfism420110505.log schemas=sfism4 remap_schema=sfism4:sfism4 table_exists_action=truncate

impdp 'system/"system$oracle"'@whrma directory=dump_dir dumpfile=full_whrma20110505.dmp log=mweb20110505.log schemas=mweb remap_schema=mweb:mweb table_exists_action=truncate

impdp 'system/"system$oracle"'@whrma directory=dump_dir dumpfile=full_whrma20110505.dmp log=macadmin20110505.log schemas=macadmin remap_schema=macadmin:macadmin table_exists_action=truncate

impdp 'system/"system$oracle"'@whrma directory=dump_dir dumpfile=full_whrma20110505.dmp log=fa20110505.log schemas=fa remap_schema=fa:fa table_exists_action=truncate

impdp 'system/"system$oracle"'@whrma directory=dump_dir dumpfile=full_whrma20110505.dmp log=rmaecn20110505.log schemas=rmaecn remap_schema=rmaecn:rmaecn table_exists_action=truncate

impdp 'system/"system$oracle"'@whrma directory=dump_dir dumpfile=full_whrma20110505.dmp log=rmaempctrl20110505.log schemas=rmaempctrl remap_schema=rmaempctrl:rmaempctrl  table_exists_action=truncate

 

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
expdp 'system/"system#test"'@mrp directory=dump_dir dumpfile=full_mrp20110510.dmp full=y logfile=full_mrp20110510.log


impdp 'system/"system$oracle"'@mrp directory=dump_dir dumpfile=full_mrp20110510.dmp log=sfis120110510.log schemas=sfis1 remap_schema=sfis1:sfis1 table_exists_action=truncate

impdp 'system/"system$oracle"'@mrp directory=dump_dir dumpfile=full_mrp20110510.dmp log=sfism420110510.log schemas=sfism4 remap_schema=sfism4:sfism4 table_exists_action=truncate

impdp 'system/"system$oracle"'@mrp directory=dump_dir dumpfile=full_mrp20110510.dmp log=mweb20110510.log schemas=mweb remap_schema=mweb:mweb table_exists_action=truncate

impdp 'system/"system$oracle"'@mrp directory=dump_dir dumpfile=full_mrp20110510.dmp log=macadmin20110510.log schemas=macadmin remap_schema=macadmin:macadmin table_exists_action=truncate

impdp 'system/"system$oracle"'@mrp directory=dump_dir dumpfile=full_mrp20110510.dmp log=fa20110510.log schemas=fa remap_schema=fa:fa table_exists_action=truncate

impdp 'system/"system$oracle"'@mrp directory=dump_dir dumpfile=full_mrp20110510.dmp log=rmaecn20110510.log schemas=rmaecn remap_schema=rmaecn:rmaecn table_exists_action=truncate

impdp 'system/"system$oracle"'@mrp directory=dump_dir dumpfile=full_mrp20110510.dmp log=rmaempctrl20110510.log schemas=rmaempctrl remap_schema=rmaempctrl:rmaempctrl  table_exists_action=truncate


impdp 'system/"system$oracle"'@mrp directory=dump_dir dumpfile=full_mrp20110510.dmp log=full_user20110510.log schemas=emd1mc,emd2gc,emd2pt,emd3mc,emd3mcn,emd3mcx,emd3wh,emdiias,emdiicai,emdiisfcas,mrp


export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
expdp 'system/"system#test"'@mis directory=dump_dir dumpfile=full_mis20110517.dmp full=y logfile=full_mis20110517.log


impdp 'system/"system$oracle"'@mis directory=dump_dir dumpfile=full_mis20110517.dmp log=full_user20110517.log schemas=dt2mis,mms,sfis1,sfism4


export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
expdp 'system/"system#test"'@dt2esd directory=dump_dir dumpfile=full_dt2esd20110517.dmp full=y logfile=full_dt2esd20110517.log


impdp 'system/"system$oracle"'@dt2esd directory=dump_dir dumpfile=full_dt2esd20110517.dmp log=full_user20110517.log schemas=dt2global_ad,esd

 

set NLS_LANG=AMERICAN_AMERICA.AL32UTF8

exp 'system/"system#test"'@dt2test wner=dt2as file=d:\backup\dt2as20110518.dmp log=d:\backup\dt2as20110518.log

exp 'system/"system#test"' wner=dt2as file=d:\backup\dt2as20110518.dmp log=d:\backup\dt2as20110518.log

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
imp dt2as/dt2as@dt2as file=dt2as20110518.dmp log=dt2as20110518.log fromuser=dt2as touser=dt2as ignore=y

 


set NLS_LANG=AMERICAN_AMERICA.AL32UTF8

expdp 'system/"""system@dbsec"""'@dt2esd directory=dump_dir dumpfile=full_dt2esd20110609.dmp full=y logfile=full_dt2esd20110609.log


export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
impdp 'system/"system$oracle"'@dt2esd directory=dump_dir dumpfile=full_dt2esd20110609.dmp log=full_user20110609.log schemas=dt2global_ad,esd content=data_only


set NLS_LANG=AMERICAN_AMERICA.AL32UTF8

exp 'system/"""system@dbsec"""' full=y file=d:\backup\full_mis20110610.dmp log=d:\backup\full_mis20110610.log


export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
imp dt2mis/dt2mis@mis file=full_mis20110610.dmp log=dt2mis_mis20110610.dmp.log fromuser=dt2mis touser=dt2mis ignore=y

imp mms/mms@mis file=full_mis20110610.dmp log=mms_mis20110610.dmp.log fromuser=mms touser=mms ignore=y

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

imp sfism4/sfism4@mis file=full_mis20110610.dmp log=sfism4_mis20110610.dmp.log fromuser=sfism4 touser=sfism4 ignore=y


export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
expdp 'system/"system@dbsec"' directory=dump_dir dumpfile=full_wip20110613.dmp full=y logfile=full_wip20110613.log


export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

expdp sfism4/dbsec4 directory=dump_dir dumpfile=R_WIP_KEYPARTS_T.dmp logfile=R_WIP_KEYPARTS_T.log tables=R_WIP_KEYPARTS_T filesize=2G
impdp sfism4/dbsec4 directory=dump_dir dumpfile=R_WIP_KEYPARTS_T.dmp logfile=R_WIP_KEYPARTS_T.log tables=R_WIP_KEYPARTS_T table_exists_action=append


exp sfism4/dbsec4 tables=R_WIP_KEYPARTS_T file=R_WIP_KEYPARTS_T1.dmp,R_WIP_KEYPARTS_T2.dmp,R_WIP_KEYPARTS_T3.dmp,R_WIP_KEYPARTS_T4.dmp,R_WIP_KEYPARTS_T5.dmp,R_WIP_KEYPARTS_T6.dmp,R_WIP_KEYPARTS_T7.dmp,R_WIP_KEYPARTS_T8.dmp,R_WIP_KEYPARTS_T9.dmp,R_WIP_KEYPARTS_T10.dmp,R_WIP_KEYPARTS_T11.dmp,R_WIP_KEYPARTS_T12.dmp,R_WIP_KEYPARTS_T13.dmp,R_WIP_KEYPARTS_T14.dmp,R_WIP_KEYPARTS_T15.dmp,R_WIP_KEYPARTS_T16.dmp,R_WIP_KEYPARTS_T17.dmp,R_WIP_KEYPARTS_T18.dmp,R_WIP_KEYPARTS_T19.dmp,R_WIP_KEYPARTS_T20.dmp,R_WIP_KEYPARTS_T21.dmp,R_WIP_KEYPARTS_T22.dmp,R_WIP_KEYPARTS_T23.dmp log=R_WIP_KEYPARTS_T2.log filesize=2GB feedback=10000000

 

imp system/system"$"oracle tables=R_WIP_KEYPARTS_T file=R_WIP_KEYPARTS_T1.dmp,R_WIP_KEYPARTS_T2.dmp,R_WIP_KEYPARTS_T3.dmp,R_WIP_KEYPARTS_T4.dmp,R_WIP_KEYPARTS_T5.dmp,R_WIP_KEYPARTS_T6.dmp,R_WIP_KEYPARTS_T7.dmp,R_WIP_KEYPARTS_T8.dmp,R_WIP_KEYPARTS_T9.dmp,R_WIP_KEYPARTS_T10.dmp,R_WIP_KEYPARTS_T11.dmp,R_WIP_KEYPARTS_T12.dmp,R_WIP_KEYPARTS_T13.dmp,R_WIP_KEYPARTS_T14.dmp,R_WIP_KEYPARTS_T15.dmp,R_WIP_KEYPARTS_T16.dmp,R_WIP_KEYPARTS_T17.dmp,R_WIP_KEYPARTS_T18.dmp,R_WIP_KEYPARTS_T19.dmp,R_WIP_KEYPARTS_T20.dmp,R_WIP_KEYPARTS_T21.dmp,R_WIP_KEYPARTS_T22.dmp log=R_WIP_KEYPARTS_T.log fromuser=sfism4 touser=sfism4 ignore=y commit=y filesize=2GB feedback=1000000

 

exp sfism4/dbsec4 tables=R_SN_DETAIL_T file=R_SN_DETAIL_T1.dmp,R_SN_DETAIL_T2.dmp,R_SN_DETAIL_T3.dmp,R_SN_DETAIL_T4.dmp,R_SN_DETAIL_T5.dmp,R_SN_DETAIL_T6.dmp log=R_SN_DETAIL_T.log fromuser=sfism4 touser=sfism4 ignore=y commit=y filesize=2GB feedback=10000000


imp system/system"$"oracle tables=R_SN_DETAIL_T file=R_SN_DETAIL_T1.dmp,R_SN_DETAIL_T2.dmp,R_SN_DETAIL_T3.dmp,R_SN_DETAIL_T4.dmp,R_SN_DETAIL_T5.dmp,R_SN_DETAIL_T6.dmp log=R_SN_DETAIL_T.log fromuser=sfism4 touser=sfism4 ignore=y commit=y filesize=2GB feedback=10000000

 


cat R_SN_DETAIL_T.txt

TABLES=R_SN_DETAIL_T
FILE=R_SN_DETAIL_T1.dmp,R_SN_DETAIL_T2.dmp,R_SN_DETAIL_T3.dmp,R_SN_DETAIL_T4.dmp,R_SN_DETAIL_T5.dmp,R_SN_DETAIL_T6.dmp,R_SN_DETAIL_T7.dmp,R_SN_DETAIL_T8.dmp,R_SN_DETAIL_T9.dmp,R_SN_DETAIL_T10.dmp
FILESIZE=2GB
QUERY="WHERE IN_STATION_TIME > TO_DATE('2009-12-30 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND IN_STATION_TIME < TO_DATE('2011-06-26 00:00:00', 'YYYY-MM-DD HH24:MI:SS')"
LOG=R_SN_DETAIL_T.log

exp sfism4/dbsec4 PARFILE=R_SN_DETAIL_T.txt

imp system/system"$"oracle tables=R_SN_DETAIL_T file=R_SN_DETAIL_T1.dmp,R_SN_DETAIL_T2.dmp,R_SN_DETAIL_T3.dmp,R_SN_DETAIL_T4.dmp,R_SN_DETAIL_T5.dmp,R_SN_DETAIL_T6.dmp log=R_SN_DETAIL_T.log fromuser=sfism4 touser=sfism4 ignore=y commit=y filesize=2GB feedback=10000000

 

cat R_WIP_TRACKING_T.txt

TABLES=R_WIP_TRACKING_T
FILE=R_WIP_TRACKING_T1.dmp,R_WIP_TRACKING_T2.dmp,R_WIP_TRACKING_T3.dmp,R_WIP_TRACKING_T4.dmp,R_WIP_TRACKING_T5.dmp,R_WIP_TRACKING_T6.dmp,R_WIP_TRACKING_T7.dmp,R_WIP_TRACKING_T8.dmp,R_WIP_TRACKING_T9.dmp,R_WIP_TRACKING_T10.dmp
FILESIZE=2GB
QUERY="WHERE IN_STATION_TIME > TO_DATE('2009-12-30 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND IN_STATION_TIME < TO_DATE('2011-06-26 00:00:00', 'YYYY-MM-DD HH24:MI:SS')"
LOG=R_WIP_TRACKING_T.log

exp sfism4/dbsec4 PARFILE=R_WIP_TRACKING_T.txt

imp system/system"$"oracle tables=R_WIP_TRACKING_T file=R_WIP_TRACKING_T1.dmp,R_WIP_TRACKING_T2.dmp log=R_WIP_TRACKING_T.log fromuser=sfism4 touser=sfism4 ignore=y commit=y filesize=2GB feedback=10000000


cat R_WIP_LOG_T.txt

TABLES=R_WIP_LOG_T
FILE=R_WIP_LOG_T1.dmp,R_WIP_LOG_T2.dmp,R_WIP_LOG_T3.dmp,R_WIP_LOG_T4.dmp,R_WIP_LOG_T5.dmp,R_WIP_LOG_T6.dmp,R_WIP_LOG_T7.dmp,R_WIP_LOG_T8.dmp,R_WIP_LOG_T9.dmp,R_WIP_LOG_T10.dmp
FILESIZE=2GB
QUERY="WHERE IN_STATION_TIME > TO_DATE('2009-12-30 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND IN_STATION_TIME < TO_DATE('2011-06-26 00:00:00', 'YYYY-MM-DD HH24:MI:SS')"
LOG=R_WIP_LOG_T.log

exp sfism4/dbsec4 PARFILE=R_WIP_LOG_T.txt

imp system/system"$"oracle tables=R_WIP_LOG_T file=R_WIP_LOG_T1.dmp log=R_WIP_LOG_T.log fromuser=sfism4 touser=sfism4 ignore=y commit=y filesize=2GB feedback=10000000

 

cat R_FAN_KEYPARTS_T.txt

TABLES=R_FAN_KEYPARTS_T
FILE=R_FAN_KEYPARTS_T1.dmp,R_FAN_KEYPARTS_T2.dmp,R_FAN_KEYPARTS_T3.dmp,R_FAN_KEYPARTS_T4.dmp,R_FAN_KEYPARTS_T5.dmp,R_FAN_KEYPARTS_T6.dmp,R_FAN_KEYPARTS_T7.dmp,R_FAN_KEYPARTS_T8.dmp,R_FAN_KEYPARTS_T9.dmp,R_FAN_KEYPARTS_T10.dmp
FILESIZE=2GB
QUERY="WHERE LINK_TIME > TO_DATE('2009-12-30 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND LINK_TIME < TO_DATE('2011-06-26 00:00:00', 'YYYY-MM-DD HH24:MI:SS')"
LOG=R_FAN_KEYPARTS_T.log

exp sfism4/dbsec4 PARFILE=R_FAN_KEYPARTS_T.txt

imp system/system"$"oracle tables=R_FAN_KEYPARTS_T file=R_FAN_KEYPARTS_T1.dmp log=R_FAN_KEYPARTS_T.log fromuser=sfism4 touser=sfism4 ignore=y commit=y filesize=2GB feedback=10000000

 

20110701

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
exp 'system/"system@dbsec"' full=y file=/data/dump_dir/full_acer20110701.dmp log=/data/dump_dir/full_acer20110701.log

imp sfis1/dbsec1 file=/data/dump_dir/full_acer20110701.dmp log=/data/dump_dir/sfis1_acer20110701.dmp.log fromuser=sfis1 touser=sfis1 ignore=y

imp sfism4/dbsec4 file=/data/dump_dir/full_acer20110701.dmp log=/data/dump_dir/sfis4_acer20110701.dmp.log fromuser=sfism4 touser=sfism4 ignore=y

imp macadmin/mac file=/data/dump_dir/full_acer20110701.dmp log=/data/dump_dir/macadmin_acer20110701.dmp.log fromuser=macadmin touser=macadmin ignore=y

imp mweb/allweb file=/data/dump_dir/full_acer20110701.dmp log=/data/dump_dir/mweb_acer20110701.dmp.log fromuser=mweb touser=mweb ignore=y


export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
exp 'system/"system@dbsec"' full=y file=/data/dump_dir/full_acer20110701.dmp log=/data/dump_dir/full_acer20110701.log

imp sfis1/dbsec1 file=/data/dump_dir/full_acer20110701.dmp log=/data/dump_dir/sfis1_acer20110701.dmp.log fromuser=sfis1 touser=sfis1 ignore=y

imp sfism4/dbsec4 file=/data/dump_dir/full_acer20110701.dmp log=/data/dump_dir/sfis4_acer20110701.dmp.log fromuser=sfism4 touser=sfism4 ignore=y


imp macadmin/mac file=/data/dump_dir/full_acer20110701.dmp log=/data/dump_dir/macadmin_acer20110701.dmp.log fromuser=macadmin touser=macadmin ignore=y


imp system/system"$"oracle file=/data/dump_dir/full_acer20110701.dmp log=/data/dump_dir/mweb_acer20110701.dmp.log fromuser=mweb touser=mweb ignore=y

 


exp 'system/"system@dbsec"' wner=sfis1 file=/data/dump_dir/sfis1_acer20110701.dmp log=/data/dump_dir/sfis1_acer20110701.log


imp sfis1/dbsec1 file=/data/dump_dir/sfis1_acer20110701.dmp log=/data/dump_dir/sfis1_acer20110701.log fromuser=sfis1 touser=sfis1 ignore=y


exp 'system/"system@dbsec"' wner=sfism4 file=/data/dump_dir/sfism4_acer20110701.dmp log=/data/dump_dir/sfism4_acer20110701.log


imp sfism4/dbsec4 file=/data/dump_dir/sfism4_acer20110701.dmp log=/data/dump_dir/sfism4_acer20110701.log fromuser=sfism4 touser=sfism4 ignore=y

 

exp 'system/"system@dbsec"' wner=mweb file=/data/dump_dir/mweb_acer20110701.dmp log=/data/dump_dir/mweb_acer20110701.log

imp system/system"$"oracle file=/data/dump_dir/mweb_acer20110701.dmp log=/data/dump_dir/mweb_acer20110701.log fromuser=mweb touser=mweb ignore=y


exp 'system/"system@dbsec"' wner=macadmin file=/data/dump_dir/macadmin_acer20110701.dmp log=/data/dump_dir/macadmin_acer20110701.log

imp system/system"$"oracle file=/data/dump_dir/macadmin_acer20110701.dmp log=/data/dump_dir/macadmin_acer20110701.log fromuser=macadmin touser=macadmin ignore=y


export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
imp cai/cai"$"dba file=/data/dump_dir/caitest.dmp log=/data/dump_dir/cai_20110818.log fromuser=caitest touser=cai ignore=y

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
exp 'system/"system@dbsec"' wner=spc file=/data/expbak/spc_ultimus20110819.dmp log=/data/expbak/spc_ultimus20110819.log

imp system/system"$"dba file=/data/dump_dir/spc_ultimus20110819.dmp log=/data/dump_dir/spc_ultimus20110819.log fromuser=spc touser=spc ignore=y


export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
exp 'system/"system@dbsec"' wner=spc file=/data/expbak/spc_ultimus20110822.dmp log=/data/expbak/spc_ultimus20110822.log

imp system/system"$"dba file=/data/dump_dir/spc_ultimus20110822.dmp log=/data/dump_dir/spc_ultimus20110822.log fromuser=spc touser=spc ignore=y

 

 

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

下一篇: 分離 Check List
请登录后发表评论 登录
全部评论

注册时间:2011-03-09

  • 博文量
    238
  • 访问量
    300839