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)
ginal Message-
> 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 sever
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
co
