Rollback Segment Trouble
From: Carmen Iannacone <carmen_at_verdi.iisd.sra.com>
Date: 11 May 1994 21:01:51 GMT
Message-ID: <2qrh3v$9k_at_snoopy.sra.com>
Date: 11 May 1994 21:01:51 GMT
Message-ID: <2qrh3v$9k_at_snoopy.sra.com>
Hi,
I've gotten the following errors during large deletes in SQL*Plus. I've checked the Server Codes and Messages manual, but I'm still somewhat unsure as to how to proceed.
ORA-01562: failed to extend rollback segment (id = 1) ORA-01628: max # extents (121) reached for rollback segment MY_ROLLBACK
Notably, why is "max # extents" 121? Should I be doing some house keeping to prevent this? I haven't gotten through the FAQ, so if you could direct me to a portion of it which is applicable, I'd appreciate it. Thanks alot! Carmen (carmen_at_sra.com) -------------------------------------------------------------------------- Carmen Iannacone (703) 558-7820 SRA Corporation 2000 15th Street North Office 1055 Arlington, Va. 22201-2640Received on Wed May 11 1994 - 23:01:51 CEST