Parallel direct load on BLOB column using SQL Loader

[sarkarp]

Hi,

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?

-Sarkar

[PAVB]

Here is a wild and untested idea to workaround "resource busy" issue; partition your table and point each SQL Loader stream to a different partition.

As per the Why is this restriction there? question, that's like the Why the chicken crossed the road? one; probably nobody knows and it is actually inmaterial, you just have to deal with your chicken being compeled to cross the road

[sarkarp]

Thanks for your suggestion. Will try it out and post the results, if interesting.

[abhaysk]

but i dont think u can still use direct method.. how about external table?