Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Loader loading problem
have you tried splitting up the input file
and appending the 2ndary files ??
is the input data a file or instream ??? try making it a seperate file also
george
bricklen13_at_hotmail.com (Bricklen Anderson) wrote in message news:<b416ca2d.0203271530.4411519a_at_posting.google.com>...
> maybe also look at CONTINUEIF, or check your error count (it may be
> crapping out because it has hit its max errors).
>
> also add a bit more specificity to your post, so there is a greater
> chance of getting an intelligent response.
>
> cheers,
>
> Bricklen
>
> league1l_at_aol.com (League1L) wrote in message news:<20020326231920.28277.00000388_at_mb-fe.aol.com>...
> > I have problem in loading huge amount of data into a partition table which is
> > partitioned by month. Data loaded are for all the months within a year. After
> > loading many records as much as 50,000, Oracle SQL loader complained "out of
> > space". Whenever it happens, we looked at the table extents and blocks
> > availables that are all O.K. Many free blocks are readily available. It happens
> > every time that big file is loaded.
> > Only partially loaded. Never complete the whole process. I use Oracle 8.1.7.
> > Please advise what I should do for this problem. We allocate enough space for
> > this table. Similiar data set is always loaded to Informix. It is still fine.
> > Appreciate any advise, all guru.
Received on Thu Mar 28 2002 - 10:24:50 CST