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 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l