Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Loader loading problem
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.
What is the specific error message? Received on Wed Mar 27 2002 - 11:22:05 CST