EXPERT RESPONSE
This type of move is pretty easy. Just follow these steps:
- Create an Undo tablespace:
CREATE UNDO TABLESPACE undo_tbs
DATAFILE '/dir/undo_tbs01.dbf' SIZE xxM
EXTENT MANAGEMENT LOCAL;
- Modify your initialization parameters:
ALTER SYSTEM SET undo_tablespace=UNDO_TBS SCOPE=spfile;
ALTER SYSTEM SET undo_retention=xxxx SCOPE=spfile;
ALTER SYSTEM SET undo_management=AUTO SCOPE=spfile;
- Bounce the instance.
- Remove the old rollback segments and their tablespace. Make sure you do not drop the SYSTEM rollback segment.
You will have to determine the optimal size for your Undo tablespace. Part of this is predicated on the undo_retention parameter, which you will also have to denote.
|
