RE: Clean temporary tablespace

From: Sinardy Xing <SinardyXing_at_bkgcomsvc.com>
Date: Wed, 12 Nov 2003 00:05:42 -0800
Message-ID: <F001.005D6592.20031112000542@fatcity.com>

Hi,

Restartup your database if possible.

If you set the datafile autoextent on then you have to recreate that tablespace, if you set it to not autoextent on for some query may fail due to not enough sorting space.

Sinardy

-----Original Message-----

Sent: 12 November 2003 14:24
To: Multiple recipients of list ORACLE-L

Hello!

How can I clean temporary tablespace? It grows up faster and faster.

--

Поцелуев Виталий Игоревич (VirVit)
Oracle 9i DBA beginner

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: VirVit
  INET: virvit_at_prodtorg.udm.net

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: Sinardy Xing
  INET: SinardyXing_at_bkgcomsvc.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). Received on Wed Nov 12 2003 - 02:05:42 CST