Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2007

    Thumbs up Unanswered: Export BLOB data to file

    Hi Friends ,

    I have database tables which contain BLOB and other binary data .

    I want to export all my database data to CSV or any other file format .
    Oracle export tools are not exporting BLOB columns to file .

    Please suggest me how to do this .

  2. #2
    Join Date
    Jun 2004
    Provided Answers: 1
    You can do this with UTL_FILE. If you google for BLOB UTL_FILE you will get several good sites that will explain what to do, & how to extract to different formats.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

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