I was trying to create a database link with the following command:
create database link vijay
connect to sys identified by pwd using 'ORCL';
The link was created, but when I query the link name from user_db_links the database link name
was found as VIJAY.WORLD.
I have even tried commenting NAMES.DEFAULT_DOMAIN entry from SQLNET.ORA file and bounced the
OS : NT 4.0
Database : Oracle 8.1.5
Any help will be highly appreciated.