Search for indexes created by anyone other than the table owner. : dba_indexes « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. dba_indexes

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>