Ora-02069 error handling methods

A DB Link must be established between one Oracle database and another Oracle database a few days ago to Insert data from one server to another.

Oracle Server A: Sid: SDH, USERID/PW: NM/NM

Oracle Server B: Sid; gsgx, USERID/PW: gs/gs create the following DB Link:

Create a db Link from B to:

Create database link testdb connect to nm identified by nm using 'sdh ';

DB Link is created successfully. Select is correct, but when Insert is executed,

I nsert into a @ testdb select * from;

The following error is reported:

Ora-02069 the Global_names for this operation must be set to True.

After analysis and searching for resources, it is found that the name of the DB Link to be created must be the same as the SID of the target database when the insert statement needs to be executed;

Create database link sdh connect to nm identified by nm using 'sdh ';

The Insert statement is successfully created!