Check to make sure that there is still space in your rbs datafile and/or
you have not reached max_extents for your rollback segments. rollback
segments will continue to extend and acquire extents from the datafile
until they reach max_extents that you set at creation. Also there may
still be room to extend but no space at O/S level. One good reason to
move on to 9i or 10g and leave undo management to the server.
Sabina.




"Mabhena Hilda "
<oracledba-ezmlmshield-x26020102.[Email address protected]
11/30/2005 04:14 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
rollback segments






I have 21 rollback segments on my db problem is as I'm running import with
commit=y the space on the rbs doesn't get released leading to "cannot
extend
rbs by .. .. error" is that how rbs should work?


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html




Oracle LazyDBA home page