SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sql loader not able to load more than 4.2 billion rows

883044Aug 18 2011 — edited Sep 23 2013

Hi,

I am facing a problem with Sql loader utility.
The Sql loader process stops after loading 342 gigs of data i.e it seems to load 4.294 billion rows out of 6.9 billion rows and the loader process completes without throwing any error.

Is there any limit on the volume of data sql loader can load ?
Also how to identify that SQL loader process has not loaded whole data from the file as it is not throwing any error ?

Thanks in Advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 21 2013

Added on Aug 18 2011

#pl, #sql

18 comments

5,986 views