A few days ago, a DB Link between one Oracle database and another ORALCE database was created to insert data from one server into another machine, due to job requirements.
Oracle Server A:SID:SDH, USERID/PW:NM/NM
Oracle Server B:SID;GSGX, USERID/PW:GS/GS establishes the following DB Link:
Create a DB Link from B to a:
Create DATABASE link TestDB connect to nm identified by nm using ' SDH ';
DB Link was created successfully, select is correct, but when the Insert is executed,
I nsert into the A@testdb select * from A;
Quote the following error:
ora-02069 The global_names of this operation must be set to True.
After analyzing and finding resources, the name of the DB Link that was created must be the same as the SID of the target database for the INSERT statement to be executed;
Create DATABASE link SDH connect to nm identified by nm using ' SDH ';
After successful creation, the Insert statement operation succeeded!