1, --- export the existing szzt-related data script szzt_match (12723); szzt_criminals (19937)
Exp zwgl/zwgl11 @ cafcm 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, --- export the data record source bzajxx row 3599 of the control database
Exp zwgl/zwgl11 @ cafcm 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, --- export the information of the person in the control database. Row 11397 is imported.
Exp zwgl/zwgl11 @ cafcm 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, --- export the relevant case information in bzajxx
"Ajxx" Row 717 is imported
Exp zwgl/zwgl11 @ cafcm 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 --- export the information of the person in tthitrslt "ryxx" 423 to be imported
Exp zwgl/zwgl11 @ cafcm 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 --- export all records in tthitrslt (executed in ftafiis) in ftafiis, and 644 rows are imported.
Exp ft/ft @ ftafiis file = D: \ daochu \ 06tthitrlst. dmp tables = (tthitrslt)
IMP ft/ft @ ftafiis file = D: \ daochu \ 06tthitrlst. dmp tables = (tthitrslt) Ignore = y
7 --- export related logical and physical card relationship records in tp_card_set "tp_card_set" 19714 rows imported
Exp zwgl/zwgl11 @ cafcm file = D: \ daochu \ 07tp_card_set.dmp tables = (cafcm. 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 = cafe-touser = cafe-tables = (tp_card_set) Ignore = y
8 --- export the fingerprint information "szzwxx" 11770 lines in szzwxx to be imported
Exp zwgl/zwgl11 @ cafcm 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 @ dblinktoftafir) union (select logicperid from tthitrslt @ dblinktoftaisi ))\"
IMP zwgl/zwgl11 @ KK file = D: \ daochu \ 08szzwxx. dmp tables = (szzwxx) Ignore = y
9 --- export the fingerprint information "xczwxx" 11795 lines in xczwxx to be imported
Exp zwgl/zwgl11 @ cafcm 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)
11789 Tiao renyuan Xinxi