Re: ORA-01562 message, WHO CAN SOLVE MY PROBLEM?

From: Randy Ramos <rmramos.gbs_at_worldnet.att.net>
Date: 1997/08/25
Message-ID: <01bcb1b4$f822ef80$687a92cf@randy>#1/1

Jouke Wilkens

You have run out of space in your rollback segments....Make them bigger or commit more often.

R2
rmramos.gbs_at_worldnet.att.net

<jouke.wilkens_at_tip.nl> wrote in article <01bca35f$da1d38a0$044c12c3_at_t273862>...
> We use ORACLE vs.7.1.
>
> 3 jobs were running at the same time:
> a. a job inserting 2 million rows in a table
> b. a direct path SQLLOAD
> c. a large query of 2 tables, resulting in a flat file after a sort.
>
> In all the 3 jobs was the error "ORA-01562: failed to extend rollback
> segment (id=1)"
> Job a. noticed on the next line "ORA-01650: unable to extend rollback
> segment ROLLBACK2 by 3839 in tablespace ROLLB".
>
> 1. Who can explain me what these errors mean?
> 2. In which situations does this error appear?
> 3. What are the most likely solutions to this?
>
> Thank you for your reaction!
>
> Jouke Wilkens
> The Netherland.
>
>
Received on Mon Aug 25 1997 - 00:00:00 CDT