I need to truncate and import data into several schemas. The tables have
lots of constraints. I can produce a script to disable and enable the
contriants but I would like to know more about the constraint_type field in
dba_constraints and what are all the SYS_ contraints? Should I disable all
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Smith, Ron
L.
Sent: Tuesday, March 11, 2003 11:50 AM
To: Multiple recipients of list ORACLE-L
Subject: Disable / enable constraints
I need to truncate and import data into several schemas. The
tables have
lots of constraints. I
Ron,
SYS_ constraints are NOT NULL constraints.
They are also those constraints placed on tables by you that you have not
named. This is why we should always name our constraints!
The Constraint_Type field is decoded as follows:
C = Check Constraint
P = Primary Key
R = Relational (Foreign Key)