SYSTEM@ZINC> sta disable_const.sql Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. SYSTEM@ZINC> sta purge_tbl_fix.sql 13119 rows deleted. 0 rows deleted. 10820 rows deleted. 0 rows deleted. 1610 rows deleted. 4349 rows deleted. 0 rows deleted. 0 rows deleted. 353446 rows deleted. 0 rows deleted. 0 rows deleted. 0 rows deleted. 511672 rows deleted. 0 rows deleted. 0 rows deleted. 0 rows deleted. 5025 rows deleted. 0 rows deleted. 0 rows deleted. 0 rows deleted. 0 rows deleted. 190003 rows deleted. 0 rows deleted. 0 rows deleted. 1386902 rows deleted. 0 rows deleted. 0 rows deleted. 3984 rows deleted. 101 rows deleted. 0 rows deleted. SYSTEM@ZINC> sta enable_const.sql Table altered. Table altered. ALTER TABLE CIRQIT.CHANGE_ORDER_ENTITY enable constraint CHANGE_ORDER_CO_ENTITY_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.CHANGE_ORDER_STATUS enable constraint CHANGE_ORDER_CO_STATUS_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.CHANGE_ORDER_ACTION enable constraint CHANGE_ORDER_ACTION_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.CHANGE_ORDER_CUSTOM_FIELD enable constraint CHANGE_ORDER_CO_CF_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.INVOICE_CHANGE_ORDER enable constraint CHG_ORD_INV_CHG_ORD_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.PPI_HISTORY enable constraint CIRQIT_USER_FK * ERROR at line 1: ORA-02298: cannot validate (CIRQIT.CIRQIT_USER_FK) - parent keys not found Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. ALTER TABLE CIRQIT.ORG_PAPER_MERCHANT_MAP enable constraint CLIENT_ORG_ID_OPMM_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.PROJECT enable constraint PROJECT_ORG_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.PROJECT_ESTIMATE_MAP enable constraint PROJ_EST_MAP_ORG_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.INVOICE enable constraint CLIENT_ORG_INVOICE_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.ORG_PRODUCT_MAP_MASTER_MAP enable constraint SYS_C0079399 * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.ORG_PRODUCT_SIZE_MAP enable constraint CLNT_ORG_ORG_PROD_SIZ_MP_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.ORG_RATING_CATEGORY_MAP enable constraint CLIENT_ORG_ORG_RATING_CAT_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.ORG_RATING_VALUE_LABEL enable constraint CLIENT_ORG_ORG_RATING_VALUE_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.ITEM_TYPE_CLIENT_ORG_MAP enable constraint CLNT_ORG_ITM_TP_CLNT_ORG_MP_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.ORG_CURRENCY_MAP enable constraint CLIENT_ORG_CURRENCY_MAP_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.ORG_SCP_RATIONALE_MAP enable constraint ORG_SCP_RATIONALE_ORG_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. ALTER TABLE CIRQIT.ORG_FILE_MAP enable constraint FILE_NBR_ORG_FILE_MAP_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.FILE_ENTITY enable constraint FILE_NBR_FILE_ENTITY_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.USER_EMAIL_LOG_MAP enable constraint EMAIL_LOG_USER_MAP_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. ALTER TABLE CIRQIT.ESTIMATE_EVENT_HISTORY enable constraint EVENT_ESTIMATE_KEY_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.INVOICE_ADDRESS enable constraint INV_ADDR_INVOICE_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.INVOICE_CUSTOM_FIELD enable constraint INVOICE_INV_CUST_FLD_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.INVOICE_DESTINATION_MAP enable constraint INVOICE_INVOICE_DEST_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.INVOICE_DISCOUNT enable constraint INVOICE_INV_DISCOUNT_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.INVOICE_LINE enable constraint INVOICE_INVOICE_LINE_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.INVOICE_STATUS enable constraint INVOICE_INV_STATUS_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.INVOICE_TAX enable constraint INVOICE_INV_TAX_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.SPEC_3RD_PARTY_CUSTOM_FIELD enable constraint SPC_3_PY_SPC_3_PY_CUST_FLD_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.ITEM_CUSTOM_FIELD enable constraint ITM_CUST_FLD_ITEM_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. ALTER TABLE CIRQIT.CUSTOM_ITEM_ORG_ENTITY_MAP enable constraint CUST_ITEM_ITEM_CLIENT_ORG_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.ORG_ITEM_TYPE_COST_CAT_MAP enable constraint OITCC_ITEM_TYPE_NAME_ORG_ID_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.MERCHANT_ORDER_ITEM enable constraint MOI_ORDER_MERCHANT_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.MERCHANT_ORDER_STATUS enable constraint MER_ORDER_STATUS_ORDER_HIS_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.MESSAGE_REPLY_MAP enable constraint MESSAGE_NBR_MESSAGE_REPLY_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.MESSAGE_REPLY_MAP enable constraint MESS_NBR_ROOT_MESS_NBR_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.MESSAGE_TO_USER_MAP enable constraint MESSAGE_TO_USER_MESSAGE_NBR_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. ALTER TABLE CIRQIT.PRICING_ENGINE enable constraint ORG_PROD_MAP_PRICING_ENGINE_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.ORG_PAPER_PRODUCT_MAP enable constraint ORG_PAP_PRD_MAP_ORG_PRD_MAP_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.ORG_PRODUCT_MATERIAL_MAP enable constraint ORG_PD_MP_ORG_PD_MTRL_MP_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.REPORT_CURRENCY_HISTORY enable constraint ORG_REPORT_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.ORG_ITEM_TYPE_SUPP_TYPE_MAP enable constraint OITSTM_PARENT_ORG_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.ORG_PAPER_COST_SAVINGS enable constraint OPCS_ORG_ID_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.ORG_EMAIL_DISTRIBUTION enable constraint OED_PBVORG_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.ORG_EMAIL_TYPE_MAP enable constraint ORG_EMAIL_TYPE_ORG_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.ORG_ESTIMATE_TYPE_MAP enable constraint ORG_ID_PBVORG_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.ORG_FILE_CATEGORY enable constraint PBVORG_ORG_ID_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.ORG_FILE_MAP enable constraint PBVORG_ORG_FILE_MAP_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.ORG_REPORT_CURRENCY_MAP enable constraint REPORT_CURRENCY_ORG_ID_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.PBVORG_CUSTOM_FIELD_HEADER enable constraint PBVORG_PBVORG_CUST_FLD_HDR_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.PBVORG_USERS enable constraint PBVORG_USER_PBVORG_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.ORG_CUSTOM_FIELD_MAP enable constraint ORG_CUST_FLD_MP_PBVORG_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.ORG_REQESTOR_MAP enable constraint ORG_ID_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.ORG_SUPP_ITEM_TYPE_MAP enable constraint ORG_ID_ORG_SUPP_IT_TYPE_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.USER_PAPER enable constraint USER_PAPER_USER_NBR_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.PBV_USER_ROLE enable constraint FK_USER_ID * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.PBVORG_USERS enable constraint FK_USER_NBR * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. ALTER TABLE CIRQIT.PROJECT_CUSTOM_FIELD enable constraint PROJ_CUST_FLD_PROJECT_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.PROJECT_ESTIMATE_MAP enable constraint PROJ_EST_MAP_PROJECT_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.PROJECT_RESOURCE_MAP enable constraint PROJECT_RESOURCE_PROJ_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.PROJECT_STATUS enable constraint PROJECT_STAT_PROJECT_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.PROJECT_TASK_MAP enable constraint PROJECT_TASK_PROJECT_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.PROJECT_RESOURCE_MAP enable constraint PROJECT_RESOURCE_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.TASK_RESOURCE_MAP enable constraint TASK_RESOURCE_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. ALTER TABLE CIRQIT.CRITERIA_COLUMN enable constraint CRIT_COL_SRCH_CRIT_MAST_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.PROJECT_SEARCH_CRITERIA enable constraint PROJ_SEARCH_CRIT_SEARCH_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.INVOICE_SEARCH_CRITERIA enable constraint SRCH_CRIT_INV_SRCH_CRIT_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.JOB_SEARCH_CRITERIA enable constraint JOB_SRCH_CRIT_SRCH_MAST_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.SPEC_WINDOW enable constraint SPEC_NBR_VER_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.SPEC_CUSTOM_FIELD enable constraint SPEC_CUST_FLD_SPEC_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.SPEC_FINISHING enable constraint SPEC_FINISHING_SPEC_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.SPEC_PAPER enable constraint SPEC_PAPER_SPEC_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.SPEC_PREPRESS enable constraint SPEC_PREPRESS_SPEC_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.SPEC_PRINTING enable constraint SPEC_PRINTING_SPEC_FK * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CIRQIT.SPEC_PRINTING_VERSION enable constraint SPEC_SPEC_PRINTING_VERSION * ERROR at line 1: ORA-02270: no matching unique or primary key for this column-list Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. SYSTEM@ZINC> spool off