Re: Row in USER_INDEXES table not deleted when constraint is dropped

capnwhit_at_yahoo.com wrote:
> If I create a unique constraint (using "alter table x add constraint
> ..."), then Oracle will create a row in the USER_CONSTRAINTS table and
> another row in the USER_INDEXES table. If I drop the constraint (using
> "alter table x drop constraint ...") then Oracle deletes both rows most
> of the time... but sometimes the row in the USER_INDEXES table is not
> dropped. Can anybody tell me what may be happening? Running 10g,
> 10.1.0.2.0.

Can you create a demo we can try?

My guess is because the index existed before the constraint was created but I'd like to try to duplicate what you are seeing.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group