Oracle Replication column Values

Requirement Description: Adds a field to a table that already exists in the test environment and manually adds data to this column of a subset of the data in the table, and now wants to be able to add the field to the formal environment and copy the values that already exist in the test environment to the formal environment. Because the test environment and the formal environment are the same as the table structure, but not in the same library, the solution is:
1. Create a new database links in the test environment
2. Copy through the following statement:

UPDATE ext_organinfo eopSET    eop.thumbnailmap = (SELECT eo.thumbnailmap                           FROM   [email protected] eo                           WHERE  eo.organ_id = eop.organ_id)WHERE  eop.organ_id IN (SELECT eo.organ_id                        FROM   [email protected] eo                        WHERE  eo.thumbnailmap IS NOT NULL )

The new database links process is as follows:
1. In the left column of Plsql, locate the database links right-click New, the database links are created as follows:

Oracle Replication column values