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

The attached JPG made it here. The message you are getting is an archive log error, saying that it can't allocate a log. The error is repeated three times. I don't know if its because you hit enter twice before taking the screen shot or you are trying to archive to three locations.

Check to make sure that there actually is disk space at where ever the LOG_ARCHIVE_DEST parameters in your INIT.ora file are pointing to. If that doesn't clear up your problem, try the recommendations made by others regarding your rollback segments.

Best!

Randall Roberts

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.
Received on Wed May 23 2001 - 13:24:43 CDT