I guess I am bit confused when I tried to create the database in Oracle 9i manually.

On Oracle8i, we have:
ROLLBACK_SEGMENTS=(RB1,RB2,RB3,RB4) in the parameter file.

I am going to create the database in Oracle9i, and I won't use OMF option, and UNDO_MANAGEMENT I set it to manual instead of AUTO(since UNDO_MANAGEMENT will use SYS_UNDO plus the name convention is not nice) since we don't use rollback and I set UNDO_MANAGEMENT=manual so the question is:

Do I have to have UNDO_SEGMENTS on my parameter file??? I add this on my init.ora and I got error.

Everything works fine if I leave as

ROLLBACK_SEGMENTS=(RB1,RB2,RB3,RB4)

another word, If I create the UNDO tablespace and create rollback segment to UNDO tablespace, everything works fine. Is this correct ????



can someone give me some advises???
Thanks


[Edited by ashley75 on 06-13-2002 at 11:18 AM]