Question on conversion LONG RAW to BLOB

I have to import data from an Oracle8 database to another Oracle8 database:
- not same structure

• LONG RAW field in one table from the ols database will become a BLOB in the new database.

SELECT ... INSERT statement doesn't work. Export/Import using SQL*Loader is not feasible because of the change of the database structure.

Can somebody help me on what to do to achieve the conversion (PL/SQL program?) ?

Thanks! Received on Sun Mar 11 2001 - 18:07:45 CST