Limitation for Data Source Upload Using the sqlldr utility

A data source with many columns hangs in the upload stage for long time and later an error occurs. This is using the Oracle sqlldr utility. When large file is provided, the SQL loader needs memory to run. Java separates the process, which has its own overhead. Therefore, memory required is almost double of what it takes normally. The only solution is to reduce the file size or increase memory available on your computer.