Re: Disabling referential integrity contraints for an entire schema?

Fred wrote:
>
> 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?

Fred,

spool 1.lst
select 'alter table ' || table_name || ' disable constraint ' || constraint_name || ';'
from user_constraints
where constraint_type = 'R';
spool off
_at_1.lst

-- 
Cheers

Sridhar Subramaniam
Avion Consulting Services
Sydney - Australia
Email : ssubrama_at_nibucorp.ccdn.otc.com.au / avion_at_ozemail.com.au

Disclaimer : All opinions are truly and just mine.