-
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]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|