Re: Disabling referential integrity contraints for an entire schema?
From: Fred Smith <smith>
Date: 1995/12/05
Message-ID: <4a22cn$sov_at_sndsu1.sedalia.sinet.slb.com>#1/1
from user_constraints;
Date: 1995/12/05
Message-ID: <4a22cn$sov_at_sndsu1.sedalia.sinet.slb.com>#1/1
Spool the output of the following query to a file, then user SQL to run the script.
select 'alter table ' ||
table_name ||
' disable constraint ' ||
constraint_name || ';'
from user_constraints;
Regards,
Fred.
fred_at_fred.nids.com (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?
Received on Tue Dec 05 1995 - 00:00:00 CET