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: [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 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).