數據庫導出道入命令匯總

imp system/foxconn158@NSD2TEST FILE=E:\c_emp.dmp TABLES=MES1.C_EMP IGNORE=Y buffer=2048000 indexes=n feedback=1000 direct=y  ROWS=YES



exp  system/nsdii_oracle197#@NSD2SA.SYSTEMPLUS.FOXCONN.COM  tables=MES1.C_EMP FILE=C:\c_emp.dmp



exp system@ipcbuodb file=(R_SHIPPING_DETAIL.dmp) tables=(SFCRUNTIME.R_SHIPPING_DETAIL) query=\"where container_time<to_date('2008-01-01','YYYY-MM-DD')\" buffer=20480000  indexes=n log=f:\ipcbu\LIST2.txt feedback=10000 direct=y filesize=2G


exp  system/nsdii_oracle197#@NSD2SA.SYSTEMPLUS.FOXCONN.COM  tables=MES4.R_TR_SN  FILE=C:\r_tr_sn.dmp query=\"where start_time>to_date('2009-04-01','YYYY-MM-DD')\" buffer=20480000  feedback=10000 direct=y filesize=200M


exp  system/nsdii_oracle197#@NSD2SA.SYSTEMPLUS.FOXCONN.COM  file=(C:\r_tr_sn.dmp) tables=(MES4.R_TR_SN) query=\"where start_time>to_date('2009-04-01','YYYY-MM-DD')\" buffer=20480000  indexes=n log=f:\LIST2.txt feedback=10000 direct=y filesize=2G




imp system@IPCBUT01.SYSTEMPLUS.FOXCONN.COM file=(E:\DBA\ipcbudb\ipcbu_sfccfg_backup_file.dmp) fromuser=SFCCONFIG  touser=SFCCONFIG buffer=20480000 grants=n indexes=n ignore=y feedback=1000
log=(E:\DBA\ipcbudb\ipcbu_sfccfg_20080707225500.log)





exp expuser/nsdiiallparts942$@NSD2SA file=(E:\ALLPARTS\R_TR_SN.dmp) tables=(MES4.R_TR_SN)
buffer=2048000 indexes=n feedback=1000 direct=y filesize=2G ROWS=YES
imp IMPUSER/nsdiitest@NSD2TEST file=D:\R_TR_SN.dmp TABLES=R_TR_SN FROMUSER=MES4 grants=n indexes=n IGNORE=Y FEEDBACK=1000