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/enabling all constraints/triggers for a schema

Re: Disabling/enabling all constraints/triggers for a schema

From: Jeremy <jeremy0505_at_gmail.com>
Date: Thu, 9 Mar 2006 09:17:35 -0000
Message-ID: <MPG.1e7a030ae3c9a9ff98a11f@news.individual.net> 





In article <1141848877.395875_at_yasure.drizzle.com>, DA Morgan says...


> Jeremy wrote:

> > There are plenty of home-grown scripts for reading the data dictionary 

> > and then generating a "disable" or "enable" constraints script - is 

> > there any native functionality in Oracle though to do this?

> > 

> > 9iR2 plus...

> 

> No. And for that I am very thankful.

> 




Because....?


-- 

jeremy


Received on Thu Mar 09 2006 - 03:17:35 CST












Original text of this message













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