Re: Disabling referential integrity contraints for an entire schema?
Date: 1995/12/07
Message-ID: <4a60bm$ehd_at_cdn_news.telecom.com.au>#1/1
In reply to a question on how to disable constraints for
an entire schema
vbanda_at_fldb1.eccdb1.pms.ford.com (Vijay's account) wrote:
>
> Hi, By updating the USER_CONSTRAINTS table and setting the status of the
> R_constraints to disable one can disable alll reffrentail integrity
> constraints of the entire schema.
You should beware that the "table" USER_CONSTRAINTS is in fact a view of the following tables: sys.con$, sys.user$, sys.obj$, sys.cdef$ in addition the tables sys.con$ and sys.user$ are used twice.
The thought of updating any of the above tables should strike fear in the heart of a DBA. Updating a catalogue table or view directly should be frowned upon. I am sure Oracle would not support such an action.....
Based on the number of new DBA's that read this group I think the ALTER Comand would have been a better recommendation.
Gary Piper. Received on Thu Dec 07 1995 - 00:00:00 CET