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