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

Hi Jouke !

    Wow ....

            When you insert data into a table ORACLE dont't fix the
            information immediatly into the table. This happens
            when you COMMIT.

            ORACLE stores your private information in rollback
            segments, so if you have long transactions, there
            is a need to make the rollback segments larger or
            make COMMITs between your inserts.

            SQLLOAD has an option for arry-commit.

Jouke Wilkens wrote:

> 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 Fri Aug 08 1997 - 00:00:00 CDT