RE: Disable / enable constraints

SYS_ contraints are the ones that when you created them you did not give a name. Oracle will automatically assign a name like 'SYS_1234567'.

You can drop tables in the schema before import. Import will automatically create tables if it does not exist.

HTH. Guang

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On 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 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
> constraints for a schema before the import or only certain types?
>
> Thanks!
> Ron
> If you are not the intended recipient of this e-mail message, any use,
> distribution or copying of the message is prohibited. Please
> let me know
> immediately by return e-mail if you have received this
> message by mistake,
> then delete the e-mail message. Thank you.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Smith, Ron L.
> INET: rlsmith_at_kmg.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: gmei
  INET: gmei_at_incyte.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).