list_all_constraints.txt
This file contains the output of the Oracle Data Dictionary view DBA_CONSTRAINTS. This information may useful when looking into why conflicts happen.
Sample file:
List of constraints
select OWNER, CONSTRAINT_NAME, CONSTRAINT_TYPE, TABLE_NAME, SEARCH_CONDITION, R_OWNER, R_CONSTRAINT_NAME, DELETE_RULE, STATUS, DEFERRABLE, DEFERRED, VALIDATED, GENERATED, RELY from dba_constraints order by 1, 2, 3
OWNER CONSTRAINT_NAME CONSTRAINT_TYPE TABLE_NAME SEARCH_CONDITION R_OWNER R_CONSTRAINT_NAME DELETE_RULE STATUS DEFERRABLE DEFERRED VALIDATED GENERATED RELY
OE ADDRESS_CUST_ID_NN C ADDRESSES "CUSTOMER_ID" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE ADDRESS_DATEC_NN C ADDRESSES "DATE_CREATED" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE ADDRESS_ID_NN C ADDRESSES "ADDRESS_ID" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE ADDRESS_PK P ADDRESSES ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE ADD_CUST_FK R ADDRESSES OE CUSTOMERS_PK NO ACTION ENABLED DEFERRABLE IMMEDIATE NOT VALIDATED USER NAME
OE CARD_CUST_ID_NN C CARD_DETAILS "CUSTOMER_ID" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE CARD_DETAILS_PK P CARD_DETAILS ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE CARD_ID_NN C CARD_DETAILS "CARD_ID" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE CARD_NUMBER_NN C CARD_DETAILS "CARD_NUMBER" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE CARD_TYPE_NN C CARD_DETAILS "CARD_TYPE" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE CUSTOMERS_PK P CUSTOMERS ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE CUSTOMER_CREDIT_LIMIT_MAX C CUSTOMERS credit_limit <= 50000 ENABLED DEFERRABLE IMMEDIATE NOT VALIDATED USER NAME
OE CUSTOMER_ID_MIN C CUSTOMERS customer_id > 0 ENABLED DEFERRABLE IMMEDIATE NOT VALIDATED USER NAME
OE CUST_CUSTID_NN C CUSTOMERS "CUSTOMER_ID" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE CUST_FNAME_NN C CUSTOMERS "CUST_FIRST_NAME" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE CUST_LNAME_NN C CUSTOMERS "CUST_LAST_NAME" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE EXPIRY_DATE_NN C CARD_DETAILS "EXPIRY_DATE" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE INVENTORIES_PRODUCT_ID_FK R INVENTORIES OE PRODUCT_INFORMATION_PK NO ACTION ENABLED NOT DEFERRABLE IMMEDIATE NOT VALIDATED USER NAME
OE INVENTORIES_WAREHOUSES_FK R INVENTORIES OE WAREHOUSES_PK NO ACTION ENABLED NOT DEFERRABLE IMMEDIATE NOT VALIDATED USER NAME
OE INVENTORY_PK P INVENTORIES ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE INVENTORY_PROODUCT_ID_NN C INVENTORIES "PRODUCT_ID" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE INVENTORY_QOH_NN C INVENTORIES "QUANTITY_ON_HAND" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE INVENTORY_WAREHOUSE_ID_NN C INVENTORIES "WAREHOUSE_ID" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE IS_VALID_NN C CARD_DETAILS "IS_VALID" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE LOGON_CUSTOMER_ID_NN C LOGON "CUSTOMER_ID" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE LOGON_LOGON_ID_NN C LOGON "LOGON_ID" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE OI_LINEITEM_ID_NN C ORDER_ITEMS "LINE_ITEM_ID" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE OI_ORDER_ID_NN C ORDER_ITEMS "ORDER_ID" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE OI_PRODUCT_ID_NN C ORDER_ITEMS "PRODUCT_ID" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE ORDERS_CUSTOMER_ID_FK R ORDERS OE CUSTOMERS_PK SET NULL ENABLED NOT DEFERRABLE IMMEDIATE NOT VALIDATED USER NAME
OE ORDER_CUSTOMER_ID_NN C ORDERS "CUSTOMER_ID" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE ORDER_DATE_NN C ORDERS "ORDER_DATE" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE ORDER_ITEMS_ORDER_ID_FK R ORDER_ITEMS OE ORDER_PK CASCADE ENABLED NOT DEFERRABLE IMMEDIATE NOT VALIDATED USER NAME
OE ORDER_ITEMS_PK P ORDER_ITEMS ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE ORDER_ITEMS_PRODUCT_ID_FK R ORDER_ITEMS OE PRODUCT_INFORMATION_PK NO ACTION ENABLED NOT DEFERRABLE IMMEDIATE NOT VALIDATED USER NAME
OE ORDER_MODE_LOV C ORDERS order_mode in ('direct','online') ENABLED DEFERRABLE IMMEDIATE NOT VALIDATED USER NAME
OE ORDER_ORDER_ID_NN C ORDERS "ORDER_ID" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE ORDER_PK P ORDERS ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE ORDER_TOTAL_MIN C ORDERS order_total >= 0 ENABLED DEFERRABLE IMMEDIATE NOT VALIDATED USER NAME
OE PRODUCT_CATEGORY_ID_NN C PRODUCT_INFORMATION "CATEGORY_ID" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE PRODUCT_DESCRIPTIONS_PK P PRODUCT_DESCRIPTIONS ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE PRODUCT_INFORMATION_PK P PRODUCT_INFORMATION ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE PRODUCT_PRODUCT_ID_NN C PRODUCT_INFORMATION "PRODUCT_ID" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE PRODUCT_PRODUCT_NAME_NN C PRODUCT_INFORMATION "PRODUCT_NAME" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE PRODUCT_STATUS_LOV C PRODUCT_INFORMATION product_status in ('orderable'
,'planned'
,'under development'
,'obsolete')
ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE TRANSLATED_DESC_NN C PRODUCT_DESCRIPTIONS "TRANSLATED_DESCRIPTION" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE TRANSLATED_NAME_NN C PRODUCT_DESCRIPTIONS "TRANSLATED_NAME" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OE WAREHOUSES_PK P WAREHOUSES ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME
OJVMSYS SYS_C005161 P OJDS$BINDINGS$ ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME