Insert the data from the database link, the client and server data inconsistency-CodePudding

Existing a Server and a client ClientPC Server, do the following

1, create a user on the Server Guest, with sys. Table1 select privilege and insert permissions, a row in the table1 nor

2, in ClientPC SQL developer to create a link to the Server database

The CREATE DATABASE LINK ServerLink
CONNECT TO "Guest" IDENTIFIED BY "123456"
USING 'SERVER_LINK';

3, in the ClientPC SQL developer to the table1 through ServerLink insert data, there is no problem

Insert into sys. Table1 @ ServerLink values (1, "ABC");

4, in the SQL developer ClientPC query just insert data, there is no problem

Select * from sys. Table1 @ ServerLink;

Question: on the Server SQL developer query table1, table is empty, not just insert data (1, "ABC"), what is the reason, how to let the Server and the client data

CodePudding user response:

Forget to COMMIT

CodePudding user response:

Is really have such "accidental"

CodePudding user response: