We help IT Professionals succeed at work.

Increase MAX_ROLLBACK_SEGMENTS

msl22
msl22 asked
on
Medium Priority
956 Views
Last Modified: 2008-03-10
Hi,

I'm working on Oracle 8i, and I need to increase the MAX_ROLLBACK_SEGMENTS parameter of my database...

Can I change it without re-creating my database ?
If I can, which command should I used to do it?

Thank you !

Mary
Comment
Watch Question

Commented:
Hi,

You need not recreate your database.  Shutdown the database cleanly, edit the MAX_ROLLBACK_SEGMENTS value in the parameter file init<sid>.ora and then restart the database.  That's it.  Then create the required no. of the rollback segments.

Thanks,
sudhar


Finalized by Moondancer - EE Moderator

Explore More ContentExplore courses, solutions, and other research materials related to this topic.