Hi all,
on 11.2.0.4 on AIX
I had this error :
alter table MYTABLE enable constraint CONST_NAME
* ERROR at line 1:
ORA-14063: Unusable index exists on unique/primary constraint key
Then I wanted REBUILD this index.
When I query dba_indexes it is not there :
SQL> select table_name, index_name ,status from dba_indexes where index_name='CONST_NAME';
no rows selected
Why ? Does it existe ?
Thank for help.