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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------
