Re: dba_segment of DEF$

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/07/12
Message-ID: <396C797D.A81@yahoo.com>#1/1

Nobody wrote:
>
> Look at this...
> OWNER SEGMENT_NAME MB
> ---------- ------------------------- -------
> --
> SYSTEM DEF$_AQCALL 161,65234
> SYSTEM DEF$_CALLDEST_PRIMARY 71,101563
>
> The tables have no data.
> How can I decrease segment size ?
>
> --
> Saludos.
> jorge_at_tice.es

alter table ... deallocate unused

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse

Received on Wed Jul 12 2000 - 00:00:00 CDT

Re: dba_segment of DEF$_AQCALL