Make index invisible - Oracle Database Script. SQL> SELECT VISIBILITY FROM dba_indexes WHERE index_name='IDX_SESS' AND OWNER='AODBA'; VISIBILIT --------- VISIBLE SQL> ALTER INDEX AODBA.IDX_SESS INVISIBLE; Index altered. SQL> select VISIBILITY from dba_indexes where index_name='IDX_SESS' and owner='AODBA'; VISIBILIT --------- INVISIBLE -- Revert again to visible. SQL> ALTER INDEX AODBA.IDX_SESS VISIBLE; Index altered.
SQL> SELECT VISIBILITY FROM dba_indexes WHERE index_name='IDX_SESS' AND OWNER='AODBA'; VISIBILIT --------- VISIBLE SQL> ALTER INDEX AODBA.IDX_SESS INVISIBLE; Index altered. SQL> select VISIBILITY from dba_indexes where index_name='IDX_SESS' and owner='AODBA'; VISIBILIT --------- INVISIBLE -- Revert again to visible. SQL> ALTER INDEX AODBA.IDX_SESS VISIBLE; Index altered.