Re: Disabling referential integrity contraints for an entire schema?
From: Vijay's account <vbanda_at_fldb1.eccdb1.pms.ford.com>
Date: 1995/12/04
Message-ID: <VBANDA.95Dec4102036_at_fldb1.eccdb1.pms.ford.com>#1/1
Date: 1995/12/04
Message-ID: <VBANDA.95Dec4102036_at_fldb1.eccdb1.pms.ford.com>#1/1
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.
In article <49nac3$gfk_at_linet02.li.net> fred_at_fred.nids.com (Fred) writes:
> From: fred_at_fred.nids.com (Fred)
> Newsgroups: comp.databases.oracle
> Date: Fri, 01 Dec 95 06:24:49 GMT
> Organization: LI Net (Long Island Network)
>
> I am looking for a quick way to disable all referential integrity contraints
> for an entire schema. I need to do this in order to use the Import facility.
> Can anybody help me?
Received on Mon Dec 04 1995 - 00:00:00 CET