RE: Urgent: Temporary Tablespaces

From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
To: <bunjibry@xxxxxxxxx>, "'Oracle-L'" <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 17 Jan 2005 18:30:46 +0100

and the answer is: don't clear it out...
if there is any need, Oracle will do that for you.
Oracle reuses temporary segments when needed.
cheers,
 
Lex.
 
----------------------------------------------------------------
Tom Kyte Seminar: http://www.naturaljoin.nl/events/seminars.html
----------------------------------------------------------------
 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Bryan Wells
Sent: Monday, January 17, 2005 18:08
To: Oracle-L
Subject: Urgent: Temporary Tablespaces

okay... another Newbie (dumb) question:

how do I clear out temporary table space?
Whats the difference beteween temp space and temporary tablespace?

--
Bryan S Wells - DBA Newbie
bunjibry@xxxxxxxxx
--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l

References:

Urgent: Temporary Tablespaces
From: Bryan Wells

RE: Urgent: Temporary Tablespaces

Other related posts: