常用導出導入腳本
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/，如需转载，请注明出处，否则将追究法律责任。
