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

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 08 Mar 2006 12:14:51 -0800
Message-ID: <1141848877.395875@yasure.drizzle.com>

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.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Wed Mar 08 2006 - 14:14:51 CST

This message: [ Message body ]
Next message: Frank van Bortel: "Re: rman restore backup of noarchive database to another server"
Previous message: DA Morgan: "Re: Database Link Question"
In reply to: Jeremy: "Disabling/enabling all constraints/triggers for a schema"
Next in thread: Jeremy: "Re: Disabling/enabling all constraints/triggers for a schema"
Reply: Jeremy: "Re: Disabling/enabling all constraints/triggers for a schema"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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