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.