- SELECT INDEX_OWNER, INDEX_NAME
- FROM DBA_IND_COLUMNS
- WHERE INDEX_NAME NOT LIKE 'BIN$%'
- MINUS
- SELECT OWNER, INDEX_NAME
- FROM DBA_INDEXES;
- SELECT O.OBJECT_NAME AS FAKE_INDEX_NAME
- FROM DBA_OBJECTS O
- WHERE O.OBJECT_TYPE = 'INDEX'
- AND NOT EXISTS (SELECT NULL
- FROM DBA_INDEXES I
- WHERE O.OBJECT_NAME = I.INDEX_NAME
- AND O.OWNER = I.OWNER);
来源: http://www.bubuko.com/infodetail-3324409.html