8 Replies Latest reply: Sep 24, 2013 2:56 AM by BluShadow RSS

    Sql loader not able to load more than 4.2 billion rows

    thundef

      Hi,

       

      I'm running into the same issue as this guy in 2011

      https://forums.oracle.com/thread/2271923?start=0&tstart=0

       

      When using SQL*Loader to load more than 4.2bil rows, it hangs at exactly 4.294.967.295 rows.

      As Benoit on StackOverflow notices, this happens to be 2^32.

      SQL*Loader stuck after loading 4.2 billion records - Stack Overflow

       

      I've now written a script to cut up my source file into chunks of 4bil rows, and will upload them using the append option in SQL*Loader.

      I'm pretty confident that that will work.

       

      So, is Oracle aware of this limitation? It's not in the documentation afaik