Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Loader loading problem
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 Wed Mar 27 2002 - 17:30:08 CST