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




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



      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