Hai Jurij Modic,
Also, You said that there is no way in Oracle9i to SELECT/INSERT BLOBS in remote database using DBLink. Its possible in Oracle10g but through OCI, JDBC and PL/SQL and not using SQL statements. Could you let let me know more about this.

Ofcourse some one said to use Snapshots, but again they are readonly. I mean we can only SELECT from them and no INSERT/UPDATE is possible if we use SNAPSHOTS. Am I right?


regards,
Dileep Tallam.