Re: disabling and enabling all constraints

On Wed, 19 Aug 1998 14:43:03 GMT, johnvue_at_gte.net <johnvue_at_gte.net> wrote:
>Oracle themselves reinforce the myth that disabling and
>renabling constraints is no big deal with statements like
>this from the "Oracle7 Server Utilies" documentation:
> "To prevent errors like these, it is a good idea to
> disable referential integerity constraints when
> importing data into existing tables."
>Oracle doesn't give you a clue as to how difficult
>it really is to re-enable the constraints accurately.

I tend to keep around recently generated exp rows=N files so I can just grep for PRIMARY KEY and CREATE INDEX statements. The "I live in a fog anyways so I deal with it with unix tools" approach. In a multi-instance development environment, just keeping creation scripts is bound to suffer from human error.

I agree, it is much more difficult to do it within the Oracle tables and appreciate your telling everyone why. I didn't want to have to write such a platform independent 4 table beast to prove to everyone my way is simpler, so I was just biting my tongue every time the issue comes up here, silently apologizing to newbie DBA's.

>

jg
--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Wed Aug 19 1998 - 17:26:16 CDT