QUOTE (Bambi Wang @ Aug 31 2012, 04:30 PM)
If you can use JAVA and JDBC, you can use getBytes and setBytes to copy BLOBs from one database to another database. Here is a sample.
blob = rs.getBlob(i + 1);
streamData = blob.getBytes(1, (int) blob.length());
insertStatement.setBytes(i + 1, streamData);
It is at least 5 times faster than data pump or export/import.
My team have developed a tool using above code and multi-threading, batch processing, etc. It is over 30 times faster than data pump for copying BLOB or CLOB. If anyone is interested, feel free to contact me for details.
Interested in knowing how you made it 30 times faster as i am also trying the same thing. my db server is on the network and the bandwidth is blocking the throughput.