Search for indexes created by anyone other than the table owner. : DBA_INDEXES « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. DBA_INDEXES

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>
SQL>

   
    
    
    
  

Related examples in the same category