Re: How to disable ALL constraints ?

Jannette wrote:
>
> From Oracle documentation:
> "Suggestion: ... it is a good idea to disable referential constraints
> when importing into an existing table. You can then re-enable the
> constraints after the import is completed."
>
> How do you disable contraints on ALL tables in one shot ?
> Can you do this through one of Ent. Manager tools or you have to do it
> in SQL+ ?
>
> Thanks
> jannette
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Look at ALL_CONSTRAINTS from which you can generate a listing - the R_CONSTRAINT_COLUMN can be used to link back the primary key of the table you are modifying.

HTH

-- 
===========================================
Connor McDonald
"These views mine, no-one elses etc etc"
connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue."