Bulk Loading BPAs in R12
Hello,
I was wondering if anyone knows the maximum number of lines within a .txt file or file size that should be bulk loaded? I tried to bulk load a file (with 60k lines or 19mb), but the concurrent program errored with the following:
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space at java.lang.reflect.Array.newArray(Native Method) at java.lang.reflect.Array.newInstance(Array.java:52) at oracle.jdbc.driver.BufferCache.get(BufferCache.java:212) at oracle.jdbc.driver.PhysicalConnection.getByteBuffer(PhysicalConnection.java:7409) at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:2792) at oracle.jdbc.driver.OraclePreparedStatement.sendBatch(OraclePreparedStatement.java:3749) at oracle.jdbc.driver.OraclePreparedStatement.alwaysOnClose(OraclePreparedStatement.java:10357) at oracle.jdbc.driver.OraclePreparedStatement.enterImplicitCache(OraclePreparedStatement.java:3114) at oracle.jdbc.driver.LRUStatementCache.addToImplicitCache(LRUStatementCache.java:238) at oracle.jdbc.driver.PhysicalConnection.cacheImplicitStatement(PhysicalConnection.java:7231) at oracle.jdbc.driver.OracleStatement.closeOrCache(OracleStatement.java:1574) at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:1541) at oracle.jdbc.driver.OracleStatementWrapper.close(OracleStatementWrapper.java:77) at oracle.jdbc.driver.OraclePreparedStatementWrapper.close(OraclePreparedStatementWrapper.java:78) at oracle.apps.icx.icatalog.loader.sql.JDBCDataLoader.processItemBatch(JDBCDataLoader.java:552) at oracle.apps.icx.icatalog.loader.sql.JDBCDataLoader.process(JDBCDataLoader.java:249) at oracle.apps.icx.icatalog.loader.processors.ItemElementProcessor.process(ItemElementProcessor.java:115) at oracle.apps.icx.icatalog.loader.handlers.ItemLineHandler.endLine(ItemLineHandler.java:456) at oracle.apps.icx.icatalog.loader.parsers.DataTXTParser.parse(DataTXTParser.java:90) at oracle.apps.icx.icatalog.loader.CatalogTXTLoaderBase.processJob(CatalogTXTLoaderBase.java:42) at oracle.apps.icx.icatalog.loader.CatalogLoaderBase.service(CatalogLoaderBase.java:141) at oracle.apps.icx.icatalog.loader.LoadRequest.start(LoadRequest.java:111) at oracle.apps.icx.icatalog.loader.LoadRequest.runProgram(LoadRequest.java:46) at oracle.apps.fnd.cp.request.Run.main(Run.java:157)
0