Re: ORA-01562 message, WHO CAN SOLVE MY PROBLEM?
Date: 1997/08/26
Message-ID: <5tu00s$dfu_at_duke.telepac.pt>#1/1
Or you can use the SQLLoader with direct option. If you use the fastloader the loading times for some 2M in a Alpha machine were a couple of minutes only.
Fernando Pereira (morgan_at_cardume.com)
CardumeSoftware
www.cardume.com
Randy Ramos wrote in article <01bcb1b4$f822ef80$687a92cf_at_randy>...
>
>
>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 Tue Aug 26 1997 - 00:00:00 CEST