Undo tablespace ..

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 ?

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

Why would you use 9.0.1? Why not 9.2.0.1?

Quote:

---

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

Code:

---

UNDO_MANAGEMENT = AUTO
UNDO_TABLESPACE = your_undo_tbs

---

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

HTH