Ravi, Try changing the next extent size to something other than its current setting, then change it back to what it was, and you should see any/all temp space not currently in use freed up. Coalesce only merges adjacent space, and not-in-use temp space is not freed up until someone needs it.
Thank you, Paul Sherman DBA Elcom, Inc. voice - 781-501-4143 (direct #) fax - 781-278-8341 (secure) email - [EMAIL PROTECTED] -----Original Message----- Sent: Tuesday, May 28, 2002 8:08 AM To: Multiple recipients of list ORACLE-L Hi All, MY DB is 8.1.7 on AIX, TEMP space is not being realeasd after sort even after alter tablespace <name> coalesce. TEMP space was created as temporary. We didn't event put ant events to not to clear. Please let me know if there is any problem. Cheers, Ravi. __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).