更新时间:2022-01-26 01:15:04
SQL> @ver
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
SQL> select index_name,owner from dba_indexes where index_name like 'I_T_%' and wner=user;
INDEX_NAME OWNER
------------------------------ ------
I_T_A SCOTT
SQL> select index_owner,index_name,column_name,table_name from dba_ind_columns where index_name like 'I_T_%' and table_owner=user;
INDEX_OWNER INDEX_NAME COLUMN_NAME TABLE_NAME
------------------------------ ------------------------------ -------------------- ----------
SCOTT I_T_A A T
SCOTT I_T_B B T
SCOTT I_T_BX B T
SQL> select object_name,object_id,data_object_id,object_type from dba_objects where object_name in ('I_T_A','I_T_B','I_T_BX');
OBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
-------------------- ---------- -------------- -------------------
I_T_A 273812 273812 INDEX
I_T_B 273813 273813 INDEX
I_T_BX 273815 273815 INDEX
SQL> SELECT obj#, dataobj#, ts#, file#, block#, bo#, flags FROM SYS.ind$ WHERE obj# IN (273812, 273813, 273815);
OBJ# DATAOBJ# TS# FILE# BLOCK# BO# FLAGS
---------- ---------- ---------- ---------- ---------- ---------- ----------
273812 273812 4 4 530 273811 2
273813 273813 4 0 0 273811 4096
273815 273815 4 4 538 273811 2
SQL> SELECT obj#, dataobj#, ts#, file#, block#, bo#, flags FROM SYS.ind$ WHERE flags=4096;
OBJ# DATAOBJ# TS# FILE# BLOCK# BO# FLAGS
---------- ---------- ---------- ---------- ---------- ---------- ----------
273813 273813 4 0 0 273811 4096