Thanks for all those replied. have a nice day!
----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, February 03, 2003 9:33 PM > Shuan - If you go to > http://www.google.com/search?hl=en > <http://www.google.com/search?hl=en&ie=ISO-8859-1&q=max_rollback_segments> > &ie=ISO-8859-1&q=max_rollback_segments > you can find a lot of information on this parameter. Oracle needs to > allocate a finite amount of memory to manage rollback segments, so there > must be a upper boundary somewhere. Unfortunately, you've hit it and must > bounce your instance to change it. Just think of it as your lucky day. ;-) > > > > Dennis Williams > DBA, 40%OCP > Lifetouch, Inc. > [EMAIL PROTECTED] > > -----Original Message----- > Sent: Monday, February 03, 2003 6:49 AM > To: Multiple recipients of list ORACLE-L > > > Dear all DBAs, > > > i'm using Oracle 8.0.5 on Linux 6.4 kernel 2.2.14. > when i try to place the rollback segment online, > it show error as below: > > SQL> ALTER ROLLBACK SEGMENT "RB28" ONLINE; > ALTER ROLLBACK SEGMENT "RB28" ONLINE > * > ERROR at line 1: > ORA-01599: failed to acquire rollback segment (28), cache space is full > (currently has (29) entries) > > If use oerr ora 1599, then > the solution it showed is to "take another rollback segment offline or > increase the > parameter max_rollback_segments" > > so that means the current rollback segment number is exceeded the > max_rollback_segment? > where's this max_rollback_segment? > > Thanks in advance. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?big5?B?c2h1YW4udGF5XChQQ0m+R7hSs9RcKQ==?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).