Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Best strategy to ETL BLOB data

rjilaniFeb 1 2010 — edited Feb 2 2010

Hi: Gurus I am in the process of doing some ETL to port an oracle data base application to other oracle database application and bit confuse about how to port Blob data tables from one system to other. Can some one tell me with their hand on experience which strategy in general suit best to import/export Blob data. I have the following options in my mind (Note: commercial ETL tool is not an option due to some operational reasons. ) and appreciate some one insights about the following options.

1. Do ETL via oracle source table to destination table via some custom JDBC code.
2. Export blob data tables as csv file, and then run the custom JDBC code on the exported csv file
3. write oracle pl/sql custom stored procedure code and use oracle dbms packages that wraps impdp/expdp utilities to do the ETL job.

Thanks in advance.