Welcome to Nikunj's Blog
Pages
(Move to ...)
Home
▼
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';
‹
›
Home
View web version