Make index invisible - oracle database script

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.