Re: Truncate and free space

Brian Peasland wrote:
> devjnr_at_gmail.com wrote:
> > Mark D Powell ha scritto:
> >
> >> Via SQLPlus you should be able to query dba_segments and/or dba_extents
> >> to immediately see the change.
> >
> >
> > Can you tell me pls which is the exact query to do this?
> >
> > Thx.
> >
>
> Try any of the following:
>
> SELECT segment_name,bytes,extents FROM dba_segments
> WHERE owner='SCOTT' AND segment_name='EMP';
>
> or
>
> SELECT segment_name,count(*) AS extents, SUM(bytes) AS bytes
> FROM dba_extents WHERE owner='SCOTT' AND segment_name='EMP'
> GROUP BY segment_name;
>
> In the above, substitute the table owner and table name for SCOTT and
> EMP respectively.
>
> HTH,
> Brian
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_nospam.peasland.net
> http://www.peasland.net
>

Thanks, Brian for providing the requested query. I missed the replay until now due to there being work for me to do.

Mark Received on Fri Sep 01 2006 - 09:33:44 CDT