index 명으로 table 찾기

OS환경 : Oracle Linux6.8(64bit)

DB 환경 : Oracle Database 11.2.0.4

쿼리 : 

set pages 1000

set lines 200

col index_owner for a10

col index_name for a17

col table_owner for a10

col column_name for a12

select * from dba_ind_columns

where index_name = 'SYS_C00368129' --index 명

order by index_name;

결과값 : 

INDEX_OWNE INDEX_NAME   TABLE_OWNE TABLE_NAME  COLUMN_NAME  COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESC

---------- ----------------- ---------- ------------------------------ ------------ --------------- ------------- ----------- ----

SMSADMIN   SYS_C00368129     SMIN   ERFCE_15      MO_NO                      2            22           0 ASC

SMSADMIN   SYS_C00368129     SMIN   ERFCE_15      STIME                1            22           0 ASC

2 rows selected.

참조 :