Re: Sort tablespace usage

From: koert54 <k_at_k.com>
Date: Sun, 17 Jun 2001 13:01:56 GMT
Message-ID: <8T1X6.41331$mR5.5444893@afrodite.telenet-ops.be>

I guess you mean a 'temporary' temporary tablespace... A temporary tablespace can't hold permament segments, only temporary... Switch to a temporary tablespace by issueing : alter tablespace x temporary ;
In a temporary tablespace the extents are reused and only deallocated when the DB
is bounced - thus reducing I/O ...

"James Williams" <willjamu_at_mindspring.com> wrote in message news:3b2b8bb3.108105176_at_nntp.mindspring.com...
> I have always thought the only space a user has for order by, group,
> etc was from his temp tablespace from the create user. Another tells
> me you can have a specail temp tablespace for sort usage only. Is his
> true? I have not seen such even though its apealing. 8.1.6.3
Received on Sun Jun 17 2001 - 08:01:56 CDT