Oracle Cross-server query inserts data

To implement data synchronization in this way by insert into the table data in the current library table Select Remote Library, the Oracle service is configured, and both remote and local services are Oracle

Insert data in the current library

?

1 2	Create Public database link Remotedb connect to username identified by password using ' db '; Create Public database link Curdb connect to username identified by password using ' Curdb ';

Where DB,CURDB is configured alias "Note that this needs to be configured on the server side of the Tnsnames.ora, if it is configured in the client Tnsnames.ora, then TNS: Unable to resolve the specified connection identifier"

Second, then you can write the statement directly

?

1 2	Insert into Tb@curdb (field) Select field from Tb@remotedb where rownum<=3

The key to this configuration is that the Tnsnames.ora needs to be configured on the server side, not on the client