Hm, I started testing, and it seems that I was wrong in my previous post.. I did some testing on 9.2. and yes, whether the index gets dropped, is dependent on its uniqueness, not the generated flag... Sorry for the confusion... Tanel. ------ > > 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 ---------------------------------------------------------------- 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 //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------