Re: Can not place rollback segment online

2003-02-03 Thread shuan.tay\(PCI鄭祺勛\)
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 >

RE: Can not place rollback segment online

2003-02-03 Thread DENNIS WILLIAMS
Shuan - If you go to http://www.google.com/search?hl=en &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 segme

RE: Can not place rollback segment online

2003-02-03 Thread Dawtrey, Lindsay L
: Can not place rollback segment online 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 &quo

Can not place rollback segment online

2003-02-03 Thread shuan.tay\(PCI鄭祺勛\)
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), c