Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Disabling check constraints

Re: Disabling check constraints

From: Valentin Minzatu <valentinminzatu_at_yahoo.com>
Date: 17 Oct 2006 15:24:52 -0700
Message-ID: <1161123892.687324.189120@h48g2000cwc.googlegroups.com> 





Alex,



I described one solution above for you:



In the title of your post you asked for check constraints to be
disabled only. You can easily change the WHERE clause to adjust it to
what you need (i.e. if you need to disable foreign key constraints as
well, then the WHERE clause can look like: WHERE constraint_type IN
('C', 'R') ). 



Cheers, 


Valentin
Received on Tue Oct 17 2006 - 17:24:52 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US