Skip to Main Content
Forums

Oracle Database Discussions

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!

Casting BLOB to BFILE - ADW

Emiliano Vasquez-OracleMay 5 2025 — edited May 5 2025

Hi,

I am trying to merge a table in ADW. My target table includes a column with BFILE type, however, the same column on my staging table is set to a BLOB type because I am not able to create external tables with a BFILE column. Is there a way, such as using an SQL/PLSQL command, to cast this BLOB data to a BFILE to merge this into the target table?

Thanks,

Emiliano.
Duplicate Post
This post has already been added here:
Casting BLOB to BFILE - ADW
Marked by L. Fernigrini 4 months ago
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Marked as duplicate
Added on May 5 2025
0 comments
41 views