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
>

Adding a column is DDL, and all DDL is handled by DML on the SYSTEM rollback segment (unless your name is Daniel Morgan, in which case some magic is accomplished by means unknown).

So if a DDL statement is causing grief with a rollback segment, something is wrong with your SYSTEM rollback segment. You haven't (I hope) set maxextents for that segment, or switched off autoextend for the SYSTEM tablespace, have you?

> 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.
>

The attached JPG didn't come through, and thank the Lord for that. This isn't a binary group, and binaries are NOT appreciated. Stick it on a website somewhere, and link it.

Regards
HJR
> 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 Fri May 18 2001 - 07:39:00 CDT