oracle exp匯出imp匯入命令記錄

1,---匯出現有的szzt相關的資料指令碼 szzt_match(12723);szzt_criminals(19937)
exp zwgl/zwgl11@cafis file=d:\daochu\01szzt_tables.dmp tables=(szzt_match,szzt_alarmlog,szzt_criminals)
imp zwgl/zwgl11@kk  file=d:\daochu\01szzt_tables.dmp  tables=(szzt_match,szzt_alarmlog,szzt_criminals) ignore=y
2,---匯出布控庫的記錄來源bzajxx 3599行
exp zwgl/zwgl11@cafis file=d:\daochu\02bzajxx.dmp tables=(bzajxx) query=\"where id>12484 and (jlzt=10 or jlzt=14) order by id asc \"
imp zwgl/zwgl11@kk  file=d:\daochu\02bzajxx.dmp  tables=(bzajxx) ignore=y
3,---匯出布控庫裡面相關的人的資訊    11397行被匯入
exp zwgl/zwgl11@cafis file=d:\daochu\03ryxx_bzajxx.dmp tables=(ryxx) query=\"where  zwbh in ((select fpcode from szzt_criminals) union (select logicfpcode from szzt_criminals)) \"
imp zwgl/zwgl11@kk  file=d:\daochu\03ryxx_bzajxx.dmp  tables=(ryxx) ignore=y
4,---匯出bzajxx裡面相關的案例資訊
 "AJXX"        717行被匯入
exp zwgl/zwgl11@cafis file=d:\daochu\04ajxx.dmp tables=(ajxx) query=\"where id in (select ajid from  (select * from bzajxx where id>12484 and (jlzt=10 or jlzt=14) order by id asc)) \"
imp zwgl/zwgl11@kk  file=d:\daochu\04ajxx.dmp  tables=(ajxx) ignore=y
5---匯出tthitrslt裡面相關的人的資訊   "RYXX"        423行被匯入
exp zwgl/zwgl11@cafis file=d:\daochu\05ryxx_tthitrlst.dmp tables=(ryxx) query=\"where zwbh in ((select probeid from tthitrslt) union (select logicperid from tthitrslt))\"
imp zwgl/zwgl11@kk  file=d:\daochu\05ryxx_tthitrlst.dmp  tables=(ryxx) ignore=y
6---匯出ftafis裡面tthitrslt裡面的所有記錄(在ftafis中執行)  644行被匯入
exp ft/ft@ftafis file=d:\daochu\06tthitrlst.dmp tables=(tthitrslt)
imp ft/ft@ftafis  file=d:\daochu\06tthitrlst.dmp  tables=(tthitrslt) ignore=y
7---匯出tp_card_set中相關的邏輯卡和物理卡關聯性記錄  "TP_CARD_SET"      19714行被匯入
exp zwgl/zwgl11@cafis file=d:\daochu\07tp_card_set.dmp tables=(cafis.tp_card_set) query=\"  trans_no in ((select fpcode from szzt_criminals) union (select logicfpcode from szzt_criminals))\"
imp zwgl/zwgl11@kk file=d:\daochu\07tp_card_set.dmp fromuser=cafis touser=cafis tables=(tp_card_set) ignore=y
8---匯出szzwxx裡面對應的指紋資訊  "SZZWXX"      11770行被匯入
exp zwgl/zwgl11@cafis file=d:\daochu\08szzwxx.dmp tables=(szzwxx) query=\" zwbh in ((select fpcode from szzt_criminals) union (select logicfpcode from szzt_criminals) union (select probeid from tthitrslt@DBLinkToFTafis) union (select logicperid from tthitrslt@DBLinkToFTafis) )\"
imp zwgl/zwgl11@kk file=d:\daochu\08szzwxx.dmp tables=(szzwxx) ignore=y

9---匯出xczwxx裡面對應的指紋資訊  "XCZWXX"      11795行被匯入
exp zwgl/zwgl11@cafis file=d:\daochu\09xczwxx.dmp tables=(xczwxx) query=\" zwbh in (select fp_code2 from szzt_match)\"
imp zwgl/zwgl11@kk file=d:\daochu\09xczwxx.dmp tables=(xczwxx)

11789tiao renyuan xinxi