CLOB update across dblink
Hi All!
I have a problem with the updating CLOB across DBLink.
I have two db:
db1 : 10.2.0.2
db2 : 10.2.0.4
On db1 be a table with CLOB column and a DBLink to db2.
On db2 be a table with CLOB column.
I did implement two solution which works in other environments:
1.
I tried to update the db2's table across the dblink with update ...db2table@dblink set clob_data = (select clob_data from db1table) where .... ! Sometimes this DML worked and updated the CLOB column in db2 but sometime the CLOB size would be 0 in the db2.
2.
After some test I create a global temporary table and a trigger which do the update on the db2. On the db1 I run the insert db2table@dblink (select id, clob_data from db1table). And this DML worked same then the other.
Did somebody meet with a same situation?
Please help me!
Atesy