Removendo um índice teimoso…

[Marcio68AlmeidaParticipante]

Veja só que obscuro…
SQL> select owner, object_name, object_type, status
2 from dba_objects
3 where object_name = 'IDX_TB7_ID_A';

OWNER OBJECT_NAME
------------------ -------------------------
INTER_ADMIN IDX_TB7_ID_A
SQL> select owner, segment_name, segment_type, tablespace_name, bytes/1024/1024
2 from dba_segments
3 where segment_name = 'IDX_TB7_ID_A';

não há linhas selecionadas
SQL> select owner, index_name, index_type, table_owner, table_name, table_type, partitioned
2 from dba_indexes
3 where index_name = 'IDX_TB7_ID_A';

não há linhas selecionadas