Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> changing temporary tablespace for all schemas

changing temporary tablespace for all schemas

From: Cristian Veronesi <c.veronesi_at_crpa.it>
Date: Fri, 23 Mar 2001 16:26:30 +0100
Message-ID: <3ABB6B26.C928C145@crpa.it>

Hello.
All my schemas use an over-dimensioned temporary tablespace called BIGTEMP and I have to free some space on the HD, so I wish to make them to use a smaller temporary tablespace called SMALLTEMP instead. Please let me know if these steps are correct (Oracle 7.3):

  1. for each schema, issue the command: ALTER USER ... TEMPORARY TABLESPACE SMALLTEMP ;
  2. ALTER TABLESPACE BIGTEMP OFFLINE ;
  3. delete BIGTEMP datafile (gulp!)

TIA, Cris

-- 

Cristian Veronesi ><(((( > http://www.crpa.it

"Ogni limite ha una pazienza" (A. De Curtis)
Received on Fri Mar 23 2001 - 09:26:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US