Access BLOB/CLOB over DBLink
Dear Gurus,
I have two database node both having oracle 11g installed.
On DB1 on there are two tables which having BLOB n CLOB column in it.
TabA
------
Id number,
Name varchar2(100),
profile BLOB
TabABackup
------
Id number,
Name varchar2(100),
profile BLOB
I want to access these table from DB2 using DB link.
Most of the time I need to transfer data from TabA to TabABackup.
Hardly one or two time I am accessing the data (BLOB) from DB1 to DB2 using DB Link.
But I m using these table's of DB1 in DB2's procedure so as to do DML with some other tables in DB2.
Could any body suggest me better approach I mean to say faster approach over DB link for playing with
BLOB/CLOB column.
Thanking in advance
Sanjeev