DBA Hub

📋Steps in this guide1/1

Make index invisible

SQL> select VISIBILITY from dba_indexes where index_name='IDX_SESS' and owner='DBACLASS'; VISIBILIT --------- VISIBLE

oracle configurationintermediate
by OracleDba
12 views
1

Make index invisible

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
SQL>
select VISIBILITY from dba_indexes where index_name='IDX_SESS' and owner='DBACLASS';
VISIBILIT
---------
VISIBLE
SQL>
ALTER INDEX DBACLASS.IDX_SESS INVISIBLE;
Index altered.
SQL>
select VISIBILITY from dba_indexes where index_name='IDX_SESS' and owner='DBACLASS';
VISIBILIT
---------
INVISIBLE
-- Revert again to visible.
SQL>
ALTER INDEX DBACLASS.IDX_SESS VISIBLE;
Index altered.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!