Re: HELP - Temporary tablespace

Abbate Carmine wrote:
>
> How clear dirty segment in temporary tablespace create as "temporary" ?
>
> Tanks Carmine Abbate.

alter tablespace temp default storage ( pctincrease 0)

(even if it is already 0, this will give SMON a prod to clean it up)

but remember that temp tablespaces are SUPPOSED to be 'full' - this is so the segments can be re-used without needing to have to reallocate space for later sorts..

HTH

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

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