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