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: Terry Dykstra <tdykstra_at_cfol.ab.ca>
Date: Fri, 16 Jul 1999 08:31:25 -0600
Message-ID: <378f4226.0@news.cadvision.com>


select owner, segment_name, segment_type from dba_segments where tablespace_name = ......

--
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.
Huy Vu wrote in message
<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 - 09:31:25 CDT

Original text of this message

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