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

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Fri, 16 Jul 1999 07:06:28 +0200
Message-ID: <932101559.2595.0.pluto.d4ee154e@news.demon.nl>

select segment_name, segment_type, extents,bytes/1024 K from dba_segments
where tablespace_name = <your tablespace name>

Hth,

Sybrand Bakker, Oracle DBA

Huy Vu <huyv_at_usa.net> wrote in message
news:8pxj3.15629$jl.19973608_at_newscontent-01.sprint.ca...
> 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 - 00:06:28 CDT