We're here to help!

list_all_constraints.txt

Follow


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
Have more questions? Submit a request

Comments