Re: Constraints

From: Michel Cadot <micadot_at_netcourrier.com>
Date: 1999/10/13
Message-ID: <7u1rn5$h7k$1@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
@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...


> Hello!

> I need to disable all constraints in whole schema.

> What should I do?

> --

> &y.

Received on Wed Oct 13 1999 - 00:00:00 CDT