Are you sure oracle can use two? I believe you would have to switch
from one to the other.

Example to move undo, (and keep same name at the end):
a. create undo undotemp with statement below, point database to
undotemp,
b. then repeat for undotbs1.
c. drop old undo tablespaces including contents and datafiles

create UNDO tablespace "UNDOTBS1" DATAFILE
'&&drive:\oradata\&&SID\undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE 8000M;

alter system set undo_tablespace=UNDOTBLS1;

undefine SID
undefine drive

-----Original Message-----
From: Effie Jennings
[mailto:oracledba-ezmlmshield-x85035793.[Email address protected]
Sent: Wednesday, November 30, 2005 6:46 PM
To: LazyDBA Discussion
Subject: 2nd Undo Tablespace

Hello,

In Oracle 9.2.0.6 on Solaris 8 I have created a second Undo tablespace.

1. Is there anything I need to do for Oracle to use this or is it
automatic?

2. How can I specify that a particular job or sqlplus session use a
specific Undo tablespace?

Thanks,

Effie



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page