Welcome to Nikunj's Blog
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';
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)