Rollback error? (ScreenShot Included) - Oracle archive error.jpg (0/1)

From: Alex Skolnick <ak_at_e-brag.com>
Date: Thu, 17 May 2001 16:35:46 GMT
Message-ID: <9hu7gto41fre5incpcunn7eo69e5tr2i3f@4ax.com>

Hi All,

I am receiving the following error when I attempt to ADD columns to a table (the table is NOT being accessed):

ORA-01562 failed to extend rollback segment number

technet.oracle.com mentions that this error message is usually followed by another, but I don't receive a followup message.

I am using SQL Plus to issue an ALTER command and after a few seconds NT opens a does window with a warning messages about my needing to archive. (View the ATTACHED .JPG for the actual message). After about 3 minutes I receive the ORA-01562 error.

I tried creating a rollback segment for the tablespace, but that didn't fix the problem. I am really in need of some help on this one.

Operating environment:
Winnt SP5
Oracle 8
Over 4 gigs of drive space available.

Any and all help would be greatly appreciated. Received on Thu May 17 2001 - 11:35:46 CDT