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

From: Mika Pekkarinen <Mika.Pekkarinen_at_enator.se>
Date: 1997/08/12
Message-ID: <33F0016C.95635F7F_at_enator.se>#1/1


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

The problem is usually lack of space in the database to extend the rollback segment.
You should 1) increase the rollbacksegment or 2) set autocommit to ON (when running SQLLOAD ?)
so all your changes to the database will be commited att 'runtime'.

Hope it's helps you

Mika Pekkarinen Received on Tue Aug 12 1997 - 00:00:00 CEST

Original text of this message