From good_dba@hotmail.com Thu, 01 Nov 2001 20:51:22 -0800
From: "Nikunj Gupta" <good_dba@hotmail.com>
Date: Thu, 01 Nov 2001 20:51:22 -0800
Subject: Re: Constraint Enable/Disable
Message-ID: <F001.003BB0F6.20011101205018@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



Hi,
 
Hope these script will help you..
 
Disable 
Constraints..
 
select 'alter table &tab disable constraint 
'||constraint_name||' cascade;'   from dba_constraints   where 
owner = upper('&owner') and   table_name = upper('&tab') 
  / 
 
Enable 
Constraints
 
select 'alter table &tab enable constraint 
'||constraint_name||';'   from dba_constraints   where owner = 
upper('&owner') and   table_name = upper('&tab')   / 

 
Try these in your test environment.. and have 
fun
 
Nikunj
 
------------------------------------Make a FREE long distance call from 
your PC!<A 
href="">http://www.eboom.com/free/
<BLOCKQUOTE dir=ltr 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  ----- Original Message ----- 
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: 
  <A title=sujatha.madan@cmc.cwo.net.au 
  href="">Sujatha Madan 
  To: <A title=ORACLE-L@fatcity.com 
  href="">Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, November 01, 2001 08:15 
  PM
  Subject: Constraint Enable/Disable
  
  
  Hi,
  Is there a way to disable all constraints, and then enable them all 
  again?
  Thanx
  Sujatha