Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DISABLE clause without CASCADE option

Re: DISABLE clause without CASCADE option

From: Thomas Pall <tpall_at_bga.com>
Date: 13 Nov 98 21:05:12 GMT
Message-ID: <364c9f08.0@feed1.realtime.net>


You must use cascade if it is part of a referential integrety constraint.

Mind you that disabling keys _drops_ the associated index. When you enable the constraint, the index is rebuilt. So be careful about specifying storage, or you will be surprised when you go to view the properites of the index.

Rajesh Bhave (rajeshb_at_india.hp.com) wrote:
: Hello

: What Oracle does when you want to disable a UNIQUE or PRIMARY KEY
: constraint that identifies referenced key of a referenced integrity
: constraint and you don't use CASCADE option. Does Oracle give error or
: does it disable the key forming the referenced key of referential
: integrity constraint.

: Thanx
: Rajesh

-- Received on Fri Nov 13 1998 - 15:05:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US