- 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.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.