Re: Foreign Key Deletion problem

From: <jkstill_at_gmail.com>
Date: 13 Oct 2005 10:55:10 -0700
Message-ID: <1129226110.657535.5440@g44g2000cwa.googlegroups.com>

Murray Sobol wrote:

> I have tried the following SQL:
> alter table fin_invoice
> disable CONSTRAINT fk7_fin_invoice
> ;
> which works correctly, but I am looking for a more generic solution:
> the name of the Foreign Key (i.e. fk7_fin_invoice) may change due to
> design changes.

Try generating the SQL from all/dba/user_constraints

>
> I have also tried the following SQL:
> alter table fin_invoice
> disable CONSTRAINT all
> ;

Think about it - do you really want to disable *all* constraints?

> I was hoping to use SQL similar to this for a trigger:
> alter trigger <name of the trigger> disable/enable
> ;
> but have not found anything yet.

Try disable all triggers:
http://oraclesvca2.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_32a.htm#2075682 Received on Thu Oct 13 2005 - 12:55:10 CDT