Undo tablespace ..

[prasadvd]

Hi

We are going to migrate our 8.1.5 db which is on win 2k adv server
to 9.0.1 . We have Undo Tablespace feature to manage Rollback
Segments in 9i. My quesiton is,

How can we implement Undo tablespace feature in 9i during/after
migration ?

[davey23uk]

create a tablespace called undo or something and set this to be your undo tablespace in your init.ora file

[stecal]

Why would you use 9.0.1? Why not 9.2.0.1?

[SANJAY_G]

Originally posted by davey23uk
create a tablespace called undo or something and set this to be your undo tablespace in your init.ora file

Additionally..
You will have to set these two parameters in init.ora

UNDO_MANAGEMENT = AUTO
UNDO_TABLESPACE = your_undo_tbs

To create UNDO tablespace see the syntax "CREATE UNDO TABLESPACE.."

HTH