When start rollback segment not online

November 30

hi to all,
i have a one problem regarding rollback segment. i have created a new database & give five rollback segment, but when i start it is offline it will not start as online.
[email protected]
Pradip Mistry,



Hello Tina,
If the overflow in a DMTS is triggered by a very high value for
NEXT_EXTENT, sometimes you can reduce the NEXT_EXTENT value instead of
extending the tablespace. Of course, the best way is to migrate to Automatic UNDO Management and set retention instead of using rbs, depending on your Oracle version.
If you have access to OSS, please also review OSS note 3155 - Termination due to tablespace overflow, it details the cause and how to avoid that in the future.
You may also review note 3807 for related error messages regarding rollback and undo segments.
Hope this helps, if you found them useful, please do award some points.

View 3 Replies


  1. mctube pro cannot download pdf
  2. ipod touch 4 dont recognise ppc g5
  3. imovie program for a1151
  4. KE30 and SAP
  5. pr to po rounding
  6. lsmw RV14BTCI
  7. ni update service disable
  8. I2S6
  9. dsccsetup ads-create no ejectur nathing
  10. inch5aa
Copyrights 2019 Fcffair BigData Resource, All rights reserved