SQL & PL/SQL

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!

Convert BLOB to BFILE -- Data Migration

2664129Apr 9 2016 — edited Apr 11 2016

HI,

I have a requirement to convert 1TB of data which is stored as BLOB in database Table. The data is to be migrated as BFILE in the sever.

Currently i am using UTL_FILE utility to create BFILE, but it's working very slow.

Please advice if there is any other utility which can be used.

P.S. The solution is to be delivered by using UNIX and PLSQL.

Thanks

Rishu

Locked Post

New comments cannot be posted to this locked post.

Locked on May 9 2016

Added on Apr 9 2016

8 comments

2,316 views