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

"Alex Skolnick" <ak_at_e-brag.com> wrote in message news:9hu7gto41fre5incpcunn7eo69e5tr2i3f_at_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.

The jpg didn't make it, nor are you expected to post them to this group. Your issue is with the SYSTEM rollback segment in the tablespace SYSTEM, as you are issuing DDL commands, and transaction log for DDL is by default in the SYSTEM rollback segment.
That said, the rollback segment either reached maxextents or there is no room in the system tablespace anymore.

Hth,

Sybrand Bakker, Oracle DBA Received on Thu May 17 2001 - 13:00:33 CDT