Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.misc -> Re: Dynamic SQL to disable constraints.

Re: Dynamic SQL to disable constraints.

From: Daniel Morgan <>
Date: Mon, 20 Sep 2004 18:23:55 -0700
Message-ID: <1095729906.800668@yasure>

Louis Frolio wrote:

> Dan, thank you for your input. One thing that bugs me about posting
> to these newgroups is that people are rather presumptious in their
> responses. When I asked how to do a certain task in pl/sql the first
> response is that what I am trying to do is all wrong instead of
> responding to how I am trying to do it, which is where my question
> lies. I had done the research on this task and in my particular
> situation disabling the constraint for an instant in time has next to
> zero impact on the sytem in question. The db change I need to make is
> on a very small domain table. I need to make some iso currency code
> updates and the whole process is over in less than a blink of an eye.
> My goal was to first disable all constraints that are blocking me,
> change the data, and then re-enable the constraints. This process
> happens while the database is in a maintenance mode which in my case
> means no users are on the system. So, I hope that others will take
> note on your delivery and on my particular case such that if they
> choose to respond and be a help, which by the way people here always
> are a huge help, that they don't presume that the person asking the
> question is doing it all wrong. At least they should not make that
> assumption without having all the facts laid out in front of them.
> That sounds like good science to me.
> Louis
> Again, thank you for your assistence.

Don't be too harsh: I have my moments too.

Remember that you are dealing with many people in many countries and cultures and for many English, the primary language of this forum, is a second or third or fourth language. You should not bring American sensibilities to the encounter.

Even if no one is in the database doing work ... it is still best to use "best practices" which in this case is to create your constraints as deferrable.

Daniel A. Morgan
University of Washington
(replace 'x' with 'u' to respond)
Received on Mon Sep 20 2004 - 20:23:55 CDT

Original text of this message