Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can I see the contents of one tablespace?
select table_name
'table' object_type
from sys.dba_tables
where tablespace_name = 'xyzzy'
union
select index_name,
'index' object_type
from sys.dba_indexes
where tablespace_name = 'xyzzy'
This will give you a list of objects in the tablespace named 'xyzzy' and label them as to whether they are tables or indexes.
Ken
Huy Vu wrote:
> Hi all,
>
> Sorry for dummy question...I would like to check what inside a tablespace as
> which tables belong to this tablespace.
>
> or if possible how can I know the size of one table.
>
> Thanks in advance for any helps.
>
> H.V
Received on Fri Jul 16 1999 - 07:21:03 CDT