Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Search for indexes created by anyone other than the table owner

SQL>  select   2        Owner,                /*Owner of the index*/   3        Index_Name,           /*Name of the index*/   4        Table_Owner,          /*Owner of the table*/   5        Table_Name            /*Name of the indexed table*/   6  from DBA_INDEXES   7  where Owner != Table_Owner and rownum < 10; SQL>