SYSTEM@ZINC> sta purge_zinc_data.sql delete from cirqit.ADDRESS * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.CIRQIT_ADDRESS_NBR_FK) violated - child record found Commit complete. 0 rows deleted. Commit complete. 0 rows deleted. Commit complete. 87258 rows deleted. Commit complete. delete from cirqit.CHANGE_ORDER * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.CHANGE_ORDER_CO_ENTITY_FK) violated - child record found Commit complete. 75896 rows deleted. Commit complete. 10566 rows deleted. Commit complete. 35596 rows deleted. Commit complete. 62675 rows deleted. Commit complete. 2221 rows deleted. Commit complete. delete from cirqit.CIRQIT_USER * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.USER_USER_CONTACT_FK) violated - child record found Commit complete. delete from cirqit.CLIENT_ORG * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.CLNT_ORG_ITM_TP_CLNT_ORG_MP_FK) violated - child record found Commit complete. 35952 rows deleted. Commit complete. 0 rows deleted. Commit complete. 200297 rows deleted. Commit complete. delete from cirqit.CUSTOM_FIELD * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.CUST_FLD_ENT_TP_MP_CUST_FLD_FK) violated - child record found Commit complete. 1718 rows deleted. Commit complete. 1693 rows deleted. Commit complete. 272 rows deleted. Commit complete. delete from cirqit.CUSTOM_FIELD_LOOKUP_VALUE * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.EST_CUST_FLD_CUST_LKUP_VAL_FK) violated - child record found Commit complete. 7713 rows deleted. Commit complete. 193825 rows deleted. Commit complete. delete from cirqit.DIGITAL_FILE * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.FILE_NBR_ORG_FILE_MAP_FK) violated - child record found Commit complete. 31218 rows deleted. Commit complete. delete from cirqit.EMAIL_LOG * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.EMAIL_LOG_USER_MAP_FK) violated - child record found Commit complete. delete from cirqit.ESTIMATE * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.REQ_FR_QUT_STAT_REQ_FR_QUT_FK) violated - child record found ORA-06512: at "CIRQIT.ESTIMATE_DELETE", line 78 ORA-04088: error during execution of trigger 'CIRQIT.ESTIMATE_DELETE' Commit complete. 0 rows deleted. Commit complete. 2375034 rows deleted. Commit complete. delete from cirqit.ESTIMATE_EVENT * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.EVENT_ESTIMATE_KEY_FK) violated - child record found Commit complete. 702861 rows deleted. Commit complete. 0 rows deleted. Commit complete. 1071486 rows deleted. Commit complete. 930366 rows deleted. Commit complete. 27169 rows deleted. Commit complete. 56569 rows deleted. Commit complete. delete from cirqit.INVOICE * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.INVOICE_INV_DISCOUNT_FK) violated - child record found Commit complete. 3915 rows deleted. Commit complete. 10055 rows deleted. Commit complete. 4296 rows deleted. Commit complete. 31146 rows deleted. Commit complete. 49298 rows deleted. Commit complete. 108895 rows deleted. Commit complete. 74 rows deleted. Commit complete. 132236 rows deleted. Commit complete. 52560 rows deleted. Commit complete. delete from cirqit.ITEM * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.ITM_CUST_FLD_ITEM_FK) violated - child record found Commit complete. 3058965 rows deleted. Commit complete. 120773 rows deleted. Commit complete. 108141 rows deleted. Commit complete. delete from cirqit.ITEM_KEY * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.ITEM_QUOTE_ITEM_KEY_FK) violated - child record found Commit complete. 254238 rows deleted. Commit complete. delete from cirqit.ITEM_TYPE_CLIENT_ORG_MAP * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.OITCC_ITEM_TYPE_NAME_ORG_ID_FK) violated - child record found Commit complete. 1373 rows deleted. Commit complete. 11552 rows deleted. Commit complete. 13330 rows deleted. Commit complete. 5696 rows deleted. Commit complete. delete from cirqit.MERCHANT_ORDER * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.MOI_ORDER_MERCHANT_FK) violated - child record found Commit complete. 127 rows deleted. Commit complete. 203 rows deleted. Commit complete. 1379 rows deleted. Commit complete. delete from cirqit.MESSAGE * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.MESSAGE_NBR_MESSAGE_REPLY_FK) violated - child record found Commit complete. 50370 rows deleted. Commit complete. 83477 rows deleted. Commit complete. 417218 rows deleted. Commit complete. 247830 rows deleted. Commit complete. 729346 rows deleted. Commit complete. delete from cirqit.ORG * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.ADDRESS_ORG_FK) violated - child record found Commit complete. 716 rows deleted. Commit complete. 806 rows deleted. Commit complete. 124147 rows deleted. Commit complete. 318 rows deleted. Commit complete. 592 rows deleted. Commit complete. 3208 rows deleted. Commit complete. 0 rows deleted. Commit complete. 1556 rows deleted. Commit complete. 1167 rows deleted. Commit complete. 24424 rows deleted. Commit complete. 1961 rows deleted. Commit complete. 224 rows deleted. Commit complete. 58720 rows deleted. Commit complete. 4682 rows deleted. Commit complete. 4540 rows deleted. Commit complete. 113801 rows deleted. Commit complete. 0 rows deleted. Commit complete. 35 rows deleted. Commit complete. 494877 rows deleted. Commit complete. 2702 rows deleted. Commit complete. delete from cirqit.ORG_PRODUCT_MAP * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.ORG_PROD_MAP_PRICING_ENGINE_FK) violated - child record found Commit complete. 436561 rows deleted. Commit complete. 2585 rows deleted. Commit complete. 210797 rows deleted. Commit complete. 3677 rows deleted. Commit complete. 3576 rows deleted. Commit complete. delete from cirqit.ORG_REPORT_CURRENCY_MAP * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.ORG_REPORT_FK) violated - child record found Commit complete. 0 rows deleted. Commit complete. 2188 rows deleted. Commit complete. 24 rows deleted. Commit complete. delete from cirqit.PBVORG * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.PBVORG_USER_PBVORG_FK) violated - child record found Commit complete. 16395 rows deleted. Commit complete. 35164 rows deleted. Commit complete. 19757 rows deleted. Commit complete. delete from cirqit.PBVUSER * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.FK_USER_ID) violated - child record found Commit complete. 68911 rows deleted. Commit complete. 1585 rows deleted. Commit complete. 603519 rows deleted. Commit complete. 52515 rows deleted. Commit complete. 43663 rows deleted. Commit complete. delete from cirqit.PRODUCT_ORDER * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.ORDER_ESTIMATE_FK) violated - child record found Commit complete. 8047893 rows deleted. Commit complete. 56 rows deleted. Commit complete. 0 rows deleted. Commit complete. delete from cirqit.PROJECT * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.PROJECT_RESOURCE_PROJ_FK) violated - child record found Commit complete. 0 rows deleted. Commit complete. 219 rows deleted. Commit complete. 1323 rows deleted. Commit complete. delete from cirqit.PROJECT_RESOURCE * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.PROJECT_RESOURCE_FK) violated - child record found Commit complete. 735 rows deleted. Commit complete. 2 rows deleted. Commit complete. 404 rows deleted. Commit complete. 661 rows deleted. Commit complete. 223508 rows deleted. Commit complete. delete from cirqit.REQUEST_FOR_QUOTE * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.REQ_FR_QUT_STAT_REQ_FR_QUT_FK) violated - child record found Commit complete. 3321061 rows deleted. Commit complete. 1048 rows deleted. Commit complete. 751888 rows deleted. Commit complete. 29529 rows deleted. Commit complete. 2 rows deleted. Commit complete. delete from cirqit.SEARCH_CRITERIA_MASTER * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.CRIT_COL_SRCH_CRIT_MAST_FK) violated - child record found Commit complete. 0 rows deleted. Commit complete. 161353 rows deleted. Commit complete. 21485 rows deleted. Commit complete. delete from cirqit.SPEC * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.SPEC_CUST_FLD_SPEC_FK) violated - child record found Commit complete. 1940 rows deleted. Commit complete. 0 rows deleted. Commit complete. 6378487 rows deleted. Commit complete. 0 rows deleted. Commit complete. 2673844 rows deleted. Commit complete. 553001 rows deleted. Commit complete. 550596 rows deleted. Commit complete. 381910 rows deleted. Commit complete. 552995 rows deleted. Commit complete. 552993 rows deleted. Commit complete. 66197 rows deleted. Commit complete. 491044 rows deleted. Commit complete. 2 rows deleted. Commit complete. 2 rows deleted. Commit complete. delete from cirqit.SUPPLIER * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.ORDER_SUPPLIER_NBR_FK) violated - child record found Commit complete. 23083 rows deleted. Commit complete. 26036 rows deleted. Commit complete. 7845 rows deleted. Commit complete. 11449 rows deleted. Commit complete. 216 rows deleted. Commit complete. 1213 rows deleted. Commit complete. 72 rows deleted. Commit complete. 1151 rows deleted. Commit complete. 2862 rows deleted. Commit complete. 4474 rows deleted. Commit complete. 22 rows deleted. Commit complete. 21811 rows deleted. Commit complete. 1454 rows deleted. Commit complete. delete from cirqit.SUPPLIER_PLANT_LOCATION * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.RFQ_PLANT_LOC_FK) violated - child record found Commit complete. 147008 rows deleted. Commit complete. delete from cirqit.SUPPLIER_PRESS_MAP * ERROR at line 1: ORA-02292: integrity constraint (CIRQIT.SUPP_WEB_BIND_SUPP_PRESS_MP_FK) violated - child record found Commit complete. 135191 rows deleted. Commit complete. 436 rows deleted. Commit complete. 216 rows deleted. Commit complete. 13879 rows deleted. Commit complete. 734 rows deleted. Commit complete. 2119 rows deleted. Commit complete. 330 rows deleted. Commit complete. 14222 rows deleted. Commit complete. 6794 rows deleted. Commit complete. 26754 rows deleted. Commit complete. 1204 rows deleted. Commit complete. 2119 rows deleted. Commit complete. 661 rows deleted. Commit complete. 31 rows deleted. Commit complete. 388 rows deleted. Commit complete. 435484 rows deleted. Commit complete. 93998 rows deleted. Commit complete. 13057 rows deleted. Commit complete. 4718 rows deleted. Commit complete. 352 rows deleted. Commit complete. SYSTEM@ZINC> spool off