All objects are in what tablespace??
437871Apr 5 2006 — edited Apr 5 2006Hi,
I have a query that produces all objects owned by a user/schema, but I would also like to see what tablespace they belong to. I can do this by type of object like Table, Index, etc. but I want this for all objects. I can not seem to find a view that has all this info. Is there one? This is the query I have so far.
select o.owner, o.object_name, o.object_type, o.created, o.status
from all_objects o
where o.owner not in ('SYS', 'SYSTEM', 'WEBDB', 'OPS$TORDBA', 'DBSNMP',
'OUTLN', 'PUBLIC', 'OMOB')
order by o.owner, o.object_name
Thanks for the help.