hi, i am facing problem, while importing data from one DB to another. The problem is with when i want to import a table which contains BLOB type data. Can any one please help me, how to import BLOB type data or how to move BLOB type data from one DB to another.
Please help me.
Do you want to simply move a table from one Oracle DB to another? Use Oracle Data Pump.
Copy data from one Oracle DB into another Oracle DB, perhaps into a different table structure? Use PL/SQL with DBMS_LOB package.
Also, have a look at the Large Objects Applilcation Developer's Guide.