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. migo stock type
  2. will z10 pair with ive-w530
  3. ive-w530 pairing issue blackberry
  4. Backup easyserver has stopped
  5. Primary BT ID
  6. how to set program run dat in rffoedi1
  7. ILF8
  8. 3QVY
  9. smallestdky
  10. smileaqq
Copyrights 2019 Fcffair BigData Resource, All rights reserved