Re: SQL*Loader rollback probs

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 1998/01/28
Message-ID: <6amkpm$ive$1@hermes.is.co.za>#1/1

Pam Richmond wrote in message <34CE1AEE.533A_at_cat.com>...
>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.
<snip>
>ORA-01562 failed to extend rollback segment (id=4)
>ORA-01628 max # extents (121) reached for rollback segment RB3

Increase the size of your rollback segments, or split the loadfile into smaller chunks and load it chunk seperately.

regards,
Billy Received on Wed Jan 28 1998 - 00:00:00 CST