Parallel direct load on BLOB column using SQL Loader
I have a requirement wherein I need to load tonnes of data in table using SQL Loader. This is done via a regular shell script.. My requirement is that I need to fire up multiple SQL Loader sessions with direct load set to true. Since all SQL Loader session try to insert data in on single table, I get the resource busy error message. If I try to set PARALLEL to true along with Direct = TRUE, I get the following error:
SQL*Loader-971: parallel load option not allowed when loading lob columns
I do have a BLOB column (storage out of row) in this table. Is there any feasible solution to overcome this restriction? I need to insert data at a very high rate and thought that the SQL Loader direct load will be a good way to do that. But it seems that SQL Loader cannot do a Direct parallel load on BLOB column.. Why is this restriction there?
Click Here to Expand Forum to Full Width