Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How can I see the contents of one tablespace?

Re: How can I see the contents of one tablespace?

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Fri, 16 Jul 1999 08:21:03 -0400
Message-ID: <378F23AF.5ADB50BD@Unforgettable.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US