| undo and roll back segments [message #152940] |
Wed, 28 December 2005 00:48  |
venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai
|
Member |
|
|
what is the difference between undo segments and roll back segments ??
oracle 9i have undo and rollback segments ..why oracle9i needs both segments ? why undo segment is introduced instead of rollback segment ?..
i searched in many websites. but i did not get clear idea..
|
|
|
|
| Re: undo and roll back segments [message #152961 is a reply to message #152940] |
Wed, 28 December 2005 02:34  |
Frank Naude
Messages: 4589
Registered: April 1998
|
Senior Member |
|
|
Oracle is busy migrating away from the old Rollback Segments to UNDO segments because they are much easier to manage.
Switch to UNDO and forget that Rollback Segments ever existed.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
