2nd Undo Tablespace

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


Oracle LazyDBA home page