Re: Dynamic SQL to disable constraints.

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1095649099.519270_at_yasure>...
> Louis Frolio wrote:
>
> > Sybrand Bakker <sybrandb_at_hccnet.nl> wrote in message news:<4s7mk0ptg22ffj9a3071g4b8u69eof5hvv_at_4ax.com>...
> >
> >>On 17 Sep 2004 05:51:55 -0700, froliol_at_yahoo.com (Louis Frolio) wrote:
> >>
> >>
> >>>I think that I may need to employ
> >>>dbms_sql but I am not sure.
> >>
> >>execute immediate works without problem.
> >>I would urge you to look into better solutions, like to find out
> >>whether you can set the constraints to deferred.
> >>This method is, ahem, yes: crap.
> >
> >
> >
> > You should at least have the courtesy to explain why the method employed is crap.
>
> Crap may be a bit too harsh a word ... perhaps doo doo would be better.
>
> The point being that there is a proper method, deferred constraints, for
> accomplishing the goal. And if you can use it ... a kludge using NDS is
> just that, a kludge. Not to mention it wrecks heck on a lot of
> resources so it won't perform or scale well.

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. Received on Mon Sep 20 2004 - 10:57:30 CDT