This content has been marked as final. Show 2 replies
925197 wrote:SELECT GLOBAL_NAME FROM GLOBAL_NAME;
I have installed oracle 11g on my machine.
When i am creating dblink with the below query
CREATE DATABASE LINK ABC
CONNECT TO Username
IDENTIFIED BY password
USING 'instance name ';
It is created dblink like below.
I dont want to create dblink like above ,I want dblink is simply
Is there any way?
UPDATE GLOBAL_NAME SET GLOBAL_NAME = NULL;
Create Database Link Without Trailing Domain Name [ID 462024.1]