Well, you're right unless you've had the nouse (the Aussies will understand
this term!) to install 9i and use system-managed undo which has this really
neat feature called dynamic extents transfer (politely) or (less politely)
extent stealing.
--
HTH. Additions and corrections welcome.
Pete
Author of "Oracle8i: Architecture and Administration Exam Cram"
Currently writing the "Oracle9i New Features for Administrators Exam Cram"
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
"Robert Chin" <robert_chin_2000_at_hotmail.com> wrote in message
news:VXXP7.15901$MX1.4916788_at_news02.optonline.net...
> > If I don't commit and reach the max extents for the segment will I
> > get an error message
>
> Yup, mate, each transaction is assigned *one* rbs (guys, correct me if I'm
> wrong on this)
>
> you'd blow your rbs, and you'd get these nasty bitchings from Oracle:
> ORA-01562: failed to extend rollback segment number xblahx
> ORA-01628: max # extents reached
>
> And at this point you're screwed because all your transactions are
> rollbacked and gone.
>
> --
> Robert Chin
>
> <peter.mckenzie_at_health.wa.gov.au>
> > If I start updating data within an sql session I am allocated a rollback
> > segment. If I don't commit and reach the max extents for the segment
will
> I
> > get an error message or will I then be given access to another rollback
> > segment?
> >
> > How does Oracle decide which rollback segment to assign ?
> >
> > Thanks
> >
> >
> >
> > ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the
> eb -----
> > http://newsone.net/ -- Free reading and anonymous posting to 60,000+
> groups
> > NewsOne.Net prohibits users from posting spam. If this or other
posts
> > made through NewsOne.Net violate posting guidelines, email
> abuse_at_newsone.net
>
>
Received on Fri Dec 07 2001 - 10:08:55 CST
