RE: Clean temporary tablespace

Ja. That was my point ... and probably why some people didn't quite understand the original question (a lot of assumption on my part, but I think that is what the confusion was about).

> -----Original Message-----
> From: Thater, William [mailto:William.Thater_at_carrier.utc.com]
> Sent: Friday, November 14, 2003 12:09 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Clean temporary tablespace
>
>
> Stephen.Lee_at_DTAG.Com scribbled on the wall in glitter crayon:
>
> > I got the impression that the poster was thinking segments allocated
> > in temp tablespace must be released, cleaned out, blown away, etc.
> > before something else can come along and use the space.
>
> i was always under the impression that you didn't need to do
> anything to the
> temp tablespace. that the segments were just reused as
> needed. am i behind
> the times here?
>
> --
> Bill "Shrek" Thater ORACLE DBA
> "I'm going to work my ticket if I can..." -- Gilwell song
> william.thater_at_carrier.utc.com
> --------------------------------------------------------------
> ----------
> Shift to the left! Shift to the right! Pop up, push down,
> byte, byte,
> byte!
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Thater, William
> INET: William.Thater_at_carrier.utc.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <Stephen.Lee_at_DTAG.Com
  INET: Stephen.Lee_at_DTAG.Com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).