Re: TEMP Tablespace problem

Maybe you can create another temp tablespace (called temp_new) on another disk, assign all users to temp_new, then offline the old temp tablespace, drop the old temp tablespace, and finally remove the old temp datafiles from OS.

HTH. Guang

On Tue, 30 Sep 2003, Teresita Castro wrote:

> Hi!!
> I am trying to change the size of my tablespace TEMP, I am not an Administrator but we really need to make this tablespace smaller.
> Already the size is 13214 Mgs, and this tablaspace is on a disk that is full, so if we can not make it smaller we are going to be in a serius trouble ( our Administrator is not here until Monday).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guang Mei
  INET: gmei_at_incyte.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).