Re: pros and cons

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Thu, 1 Apr 2004 11:54:27 +0300
Message-ID: <05b501c417c6$f0938660$6df923d5@porgand>

Hi!

> In the case of a unique index, any time you diable the corresponding
> constraint, the index will be dropped. (It has to be, else the column
> would still have the unique property, due to the index.)

By the way, whether the index is dropped or not upon PK/UK constraint disabling, is dependent on whether the index is system generated or not (the generated column on dba_indexes). You can have an unique index used used for a constraint, but it doesn't get dropped if the index is created manually (with create index before constraint creation or during constraint creation using the "using index (create index... )" clause).

Tanel.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Apr 01 2004 - 02:50:53 CST