Oracle9i How to convert from undo tables to rollback segments

Advertisement
November 30

Hi,
Anyone try before converting from UNDO management to using rollback segment....What are the procedures for the conversion...
Thank You...

Advertisement

Replay

Hi,
Follow these steps to convert from Auto UNDO to Rollback Segs....
1. With the database opened, create a rollback tablespace and then create some rollback segments and bring them online like this
CREATE ROLLBACK SEGMENT RBS1 TABLESPACE RBS;
ALTER ROLLBACK SEGMENT RBS1 ONLINE;
2. Then edit the PFILE and modify these parameters
Add: ROLLBACK_SEGMENTS=(RBS1,RBS2,RBS3....)
Comment: UNDO_MANAGEMENT=AUTO and UNDO_TABLESPACE=UNDOTBS or whatever name you have for your UNDO tablespace.
3. Shutdown the database gracefully(normal).
4. Startup pfile=<Pfile path>
5. Sync these new parameter changes to the SPFILE by recreating the SPFILE.
6. Take a full level 0 backup of your database as the structure has changed.
The next time you start the database, it will use the SPFILE which is same as the PFILE.
Regards.

View 2 Replies

Tags:

  1. application nokia rm-243 6120c(b20.01)
  2. pubsubagent making cpu run at 100
  3. bapi_po_create1 extension
  4. elitepad 900 shutsdown
  5. 33R1
  6. drovelcl
  7. 6LVT
  8. reviewrwz
  9. dollar6oc
  10. LGZ0
Copyrights 2019 Fcffair BigData Resource, All rights reserved