I'm trying to load 30 MB of excel file to oracle database. Its a direct load no transformation.
But still am getting error GC overhead limit exceeded and sometimes java heap space.
It should not come because Job will be reading record by record from file am putting in DB, but what is the meaning of this error at this point ? I'm not storing in memory or somewhere else, just a direct load.
Any suggestion please ?