Re: Resize TEMP tablespace datafile

From: Tom <tomNOSPAM_at_teameazyriders.com>
Date: Fri, 23 Jan 2004 17:33:03 -0000
Message-Id: <1074879195.30954.0@nnrp-t71-01.news.uk.clara.net>

> Can do with out taking it down - create a new one (and cap it, if you
> don't like large files, using the maxsize parameter), alter all users
> to use the new one as temporary ts, and drop the old one, after
> making sure it's not used by (long-)running transactions

thanks Frank however do you know what might cause what i'm seeing.

This is what i have done so far......

CREATE TABLESPACE TEMP2 DATAFILE '/u02/oradata/XXXX/temp2_01_SOL.dbf' SIZE 10M REUSE DEFAULT STORAGE ( INITIAL 256K NEXT 256K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) TEMPORARY; ALTER DATABASE DATAFILE '/u02/oradata/XXXX/temp2_01_SOL.dbf' AUTOEXTEND ON MAXSIZE 1024M;

ALTER USER XXXX TEMPORARY TABLESPACE TEMP2; but then when logging in with that user i do a ...

SQL> select tablespace_name from user_tablespaces;

TABLESPACE_NAME

---

TEMP
USERS
MAIN the TEMP tablespace has not altered.

Any ideas as to what i'm doing wrong? This is a test system and there are no other connected users.

thanks Received on Fri Jan 23 2004 - 11:33:03 CST