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 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