Re: How to disable ALL constraints ?

select 'alter table '||table_name||' disable constraint '||constraint_name||';'
from user_constraints;

Then run the produced output

select 'alter table '||table_name||' enable constraint '||constraint_name||';'
from user_constraints;

Will set them back.

--
Regards

Jason

____________________________________________________________________________
__

  Jason Pepper - Enterprise Internet Tools Product Management
____________________________________________________________________________
__

Opinions are mine and do not necessarily reflect those of Oracle Corporation

Jannette <jannetteyiu_at_my-deja.com> wrote in message
news:86e56h$17r$1_at_nnrp1.deja.com...


> 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.