Oracle Database Discussions

Hi Friends,

Database: 10.2.0.3
OS: windows xp sp2

From the following link i read that when we rename undo tablespace, undo_tablespace parameter will be updated (if we are using spfile)

http://www.dbazine.com/blogs/blog-cf/chrisfoot/oracle10ghiddenfeat2

"If the tablespace being renamed is an undo tablespace, Oracle will perform the additional step of updating the UNDO_TABLESPACE parameter in the SPFILE. "

But when i tried the same, its not updating the parameter.

SQL> create undo tablespace undotbs2
2 datafile 'C:\oracle\oradata\orcl\undotbs2.dbf' size 10m;

Tablespace created.

SQL> show parameter undo

NAME TYPE VALUE
------------------------------------ ------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL> alter system set undo_tablespace='UNDOTBS2' scope=both;

System altered.

SQL> show parameter undo

NAME TYPE VALUE
------------------------------------ ------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS2
SQL> alter tablespace undotbs2 rename to undotbs3;

Tablespace altered.

SQL> show parameter undo

NAME TYPE VALUE
------------------------------------ ------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS2
SQL> show parameter undo

SQL> show parameter spfile

NAME TYPE VALUE
------------------------------------ ------- ------------------------------
spfile string C:\ORACLE\D001\DATABASE\SPFILE
ORCL.ORA

Do we need to manually update the parameter? If so what is the author's intention?

I didn't tried this on Unix box. Will there be any difference of the same steps above in unix box?

thanks in advance.