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.
