Re: Constraints
From: Michel Cadot <micadot_at_netcourrier.com>
Date: 1999/10/13
Message-ID: <7u1rn5$h7k$1_at_oceanite.cybercable.fr>#1/1
Date: 1999/10/13
Message-ID: <7u1rn5$h7k$1_at_oceanite.cybercable.fr>#1/1
This script generate a file with all the statements disabling the foreign constraints. You only have to execute this generated file.
set feedback off
set pagesize 0
set linesize 100
set trimspool on
spool script
select 'alter table '||table_name||' disable constraint '||constraint_name||';'
from user_constraints where constraint_type='R' order by table_name,
constraint_name;
spool off
set feedback on
_at_script
-- Regards Michel Andrey Petrashenko <andrey_at_scs.ntu-kpi.kiev.ua> a Êcrit dans le message : 380472D5.EFC4A35E_at_scs.ntu-kpi.kiev.ua...Received on Wed Oct 13 1999 - 00:00:00 CEST
> Hello!
> I need to disable all constraints in whole schema.
> What should I do?
> --
> &y.