select  i.table_owner,
        i.table_name,
        i.owner index_owner,
        i.index_name
  from  dba_indexes i,
        dba_tables t
  where upper(i.table_name) like '%PR1_%'
    and i.uniqueness = 'NONUNIQUE' -- in general unique index can be also made local if it includes partitioning column(s).
    and t.owner = i.table_owner
    and t.table_name = i.table_name
    and t.partitioned = 'YES' -- table must be partitioned to have local index
    and not exists (
                    select  1
                      from  dba_part_indexes pi
                      where pi.owner = i.table_owner
                        and pi.index_name = i.index_name
                        and pi.locality = 'LOCAL' -- index is already local
                   )
/

like '%PR1_%'

like '%PR1\_%' escape '\'