Quote Originally Posted by ebrian
INSERT & SELECT of LOBS are no problem via dblink.
In 9i? I don't think so. Would you care to demonstrate how would you select LOB columns *directly* from the remote table over database link on 9i?

In 10gRel2 you can access remote LOBs, but only through OCI, JDBC, and PL/SQL interfaces, not directly with SQL.