Tuesday, August 16, 2011

How to find the which objects in which tablespace OR list of objects in tablespace.

select owner, table_name, tablespace_name
from dba_tables
where table_name='EMP';


select owner, table_name, tablespace_name
from dba_tables
where tablespace_name='PSAPSR3USR';