Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: show table space
Hi Peter, this will do it:
clear columns breaks
col KBYTES head 'Used|Kbytes'
col Segment_name for a30
col TABLESPACE_NAME for A18
break on Segment_name
select substr(owner,1,12) Owner
,substr(segment_name,1,30) Segment_name ,tablespace_name ,substr(segment_type,1,6) type ,rtrim(to_char((bytes/1024),'999,999,999')) KBytes ,rtrim(to_char(extents,'99999')) Extfrom sys.DBA_SEGMENTS
cheers,
Roelof Schierbeek; DBA
<cmk128_at_hotmal.cm> wrote
> Hi
> I want to know how many space of a table has consumed, may i know
> how to ??
> i cannot select the information from table space.
> thanks
> from Peter
Received on Wed May 24 2006 - 03:43:38 CDT