Try using sqlldr 'direct' load, direct=true. This will avoid allocating
space for rollback which may solve the problem.
Regards
Simon
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Computing World Ltd. stocks the "Interior Design Wheel" a brilliant new tool
for the home decorator. With this tool you can create great looking colour
schemes in seconds! The "Interior Design Wheel" is on special offer at only
£7.99 including postage & packing. Visit the website
www.computing-world.co.uk for more details.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"League1L" <league1l_at_aol.com> 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 Apr 03 2002 - 12:17:14 CST
