dba_index and dba_ind_columns



How will you find if there is an index created on a table.

column table_owner format a15
column table_name format a20
column index_name format a20
column column_name format a20
Select index_owner, table_name, index_name, column_name FROM dba_ind_columns where INDEX_OWNER='schema' AND table_name='tablename';


Comments

Popular posts from this blog

ORACLE BACKUP AND RECOVERY