Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Loader loading problem

Re: SQL Loader loading problem

From: Ed prochak <ed.prochak_at_alltel.com>
Date: 27 Mar 2002 09:22:05 -0800
Message-ID: <e51b160.0203270922.304dc605@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US