users own tables

how to list of all users who own tables in more than one tablespace.

Something like this?

Code:

---

select owner
  from (select owner,count(tablespace_name) from dba_tables group by owner)
  group by owner
  having count(*)>1
/

---

HTH,
Erik

Code:

---

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

---

cool trumps simple every time!