| Moving from rollback segemnts to AUM [message #150309] |
Wed, 07 December 2005 03:10  |
ankurgodambe
Messages: 45
Registered: March 2005
|
Member |
|
|
Hi,
I have upgraded my database from 8.1.6 to 9.2.0.7. I also want to do away with rollback segemnts and configure Automatic undo management. To achieve this here is what i am doing:
1. Create undo tablespace with the command:
create undo tablespace undotbs1 "path" size xxx extent management local;
2. Shutdown the database and change init.ora file:
undo_tablespace=undotbs1
undo_management=auto
3. Startup and drop all the rollback segments in rbs tablespace(rbs tablespace is where i had rollback segments in 8.1.6).
drop rollback segment rbs1;
...
drop rollback segment rbs16;
4. Finally droppping the rbs tablespace:
drop tables rbs;
This has woked for me. But what i would like to know is of there is anyone who has ever done this? and if there is something i am missing out on?
Thanks
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
