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

I don't know if an easier way is possible, but I usually run this script for that:

set pages 0
set feed off
set pause off
set head off
spool ctdisable.sql
select 'ALTER TABLE ' || table_name || ' DISABLE CONSTRAINT ' || constraint_name ||

       ';'
from user_constraints
where constraint_type = 'R';
spool off
start ctdisable.sql

hope this can help you. Received on Sun Dec 03 1995 - 00:00:00 CET