Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*Loader rollback probs

Re: SQL*Loader rollback probs

From: Joel Garry <joelga_at_pebble.ml.org>
Date: 1998/01/30
Message-ID: <6atukl$3gp$1@pebble.ml.org>#1/1

In article <34CE1AEE.533A_at_cat.com>,
Pam Richmond <Richmond_Pamela_D_at_cat.com> wrote:
>I have been using SQL*Loader to successfully import fixed-width flat
>file data into an Oracle database. We modified the data recently, and
>some blank fields were filled in with data. This seems to have caused
>SQL*Loader to run out of storage for the rollback.
>
>I am using Personal Edition 7. The file is 11.5M. I'm using REPLACE
>when I run SQL*Loader. I tried to change the maxextents, but it is
>already set to 121, and it says I can't make it any larger than that.
>
>Following is the error:
>926:Oci error while executing deleting (due to REPLACE keyword) from
>table for table xyz
>ORA-01562 failed to extend rollback segment (id=4)
>ORA-01628 max # extents (121) reached for rollback segment RB3
>
>What can I do to fix this?
>Thanks,
>Pam Richmond

Your rollback segment RB3 is too small. Try creating a new rollback segment that is much larger, and take all the others offline. You want a large INITIAL value in your storage statement when you create it, so you don't have to extend. In addition to what everyone else said, since if it is too small for the load, it will probably be too small during some processing later.

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!
Received on Fri Jan 30 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US