How Oracle replicates Clob\blob field data from a remote database to a local database via Datalink

Oracle does not support copying the Clob/blob field data from a remote database table directly to the local database via the databases link.

SQL like the following cannot be performed. (The Ipop_topic table has a CLOB field)

INSERT INTO Ipop_topic
SELECT * from [email protected] where application_id=1000

However, we can use the global temporary table to copy the data to a temporary table, and then move from the staging table to your destination table.

Create global temporary table Ipop_topic_temp
As select * from [email protected] where rownum=1

INSERT INTO Ipop_topic_temp

SELECT * from [email protected] where application_id=1000

INSERT INTO Ipop_topic
SELECT * FROM Ipop_topic_temp

Commit

How Oracle replicates Clob\blob field data from a remote database to a local database via Datalink