Re: SQL*Loader rollback probs

From: Boroskie <boroskie_at_ix.netcom.com>
Date: 1998/02/02
Message-ID: <6b3l3d$qcs@dfw-ixnews11.ix.netcom.com>#1/1

You could use alter rollback segment xxxxx shrink and also create a large tablespace as a temporary area for the sql loader user. Also, create a big rollback segment and set the sql loader session to use this rollback segment.

Best of luck, Boroskie(boroskie_at_ix.netcom.com)

In article <34CE1AEE.533A_at_cat.com>, Richmond_Pamela_D_at_cat.com says...
>
>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> Received on Mon Feb 02 1998 - 00:00:00 CST