Re: Disabling referential integrity contraints for an entire schema?

> > I am looking for a quick way to disable all referential integrity contraints
> > for an entire schema. I need to do this in order to use the Import facility.
> > Can anybody help me?
>
>

Have you ever written sql code to create sql code???? you can do the following :

select 'alter table',table_name,'disable constraint',constraint_name,';' from user_constraints where status='ENABLED';

just spool the file out and presto you have all the statements you need afterwards just do the reverse where status='DISABLED';

John Jones			| my views are my own.........
Oracle Consultant		| no matter what company they are
john_at_iluvatar.tip.duke.edu	| coming from.
--------------------------------------------------------------------