users own tables

[slimdave]

select
   owner
from
   dba_tables
where
   partitioned = 'NO'
group by
   owner
having count(distinct tablespace)>1
union
select
   owner
from
   dba_tab_partitions
group by
   owner
having count(distinct tablespace)>1