Oracle-L: Re: TEMP Tablespace problem

From: Yechiel Adar <adar76_at_inter.net.il>
Date: Wed, 01 Oct 2003 06:54:32 -0800
Message-ID: <F001.005D1B02.20031001065432@fatcity.com>

If you can stop the users then simply drop the tablespace and remove the datafile, then crate new smaller temp. If you can not stop the users do:

1) Create new small temp;
2) Alter all users to use the new temp.
3) Drop temp , after you are sure that none of the users is using it.

Yechiel Adar
Mehish

Original Message ----- From: Teresita Castro To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 01, 2003 4:19 PM Subject: Re: TEMP Tablespace problem

9.2i

>>> breitliw_at_centrexcc.com 09/30/03 08:54PM >>>
What is the Oracle version?

At 06:24 PM 9/30/2003 -0800, you 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).

  Wolfgang Breitling
  Centrex Consulting Corporation
  http://www.centrexcc.com

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

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 Oct 01 2003 - 09:54:32 CDT