DECLARE
   cursor 	c_get_indexes IS
    select i.owner, i.index_name, p.partition_name
    from dba_indexes i, dba_ind_partitions p
    where 
    i.table_name like '%' and
    i.index_name=p.index_name(+)
    and i.owner like 'SAP%'
    and (i.LOGGING='NO' or p.LOGGING='NO')
    ;

BEGIN
   FOR r_indexes in c_get_indexes LOOP
      IF r_indexes.partition_name IS NULL THEN
         DBMS_OUTPUT.PUT_LINE (r_indexes.index_name);
      ELSE
         DBMS_OUTPUT.PUT_LINE (r_indexes.index_name || ' - ' || r_indexes.partition_name);
      END IF;
   END LOOP;
END;