Parallel direct load on BLOB column using SQL Loader
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Parallel direct load on BLOB column using SQL Loader

Hybrid View

  1. #1
    Join Date
    Sep 2007
    Posts
    2

    Parallel direct load on BLOB column using SQL Loader

    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

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Sep 2007
    Posts
    2
    Thanks for your suggestion. Will try it out and post the results, if interesting.

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    but i dont think u can still use direct method.. how about external table?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width