ORA-12154 error when using database link
SQL> col host_name format a20
SQL> set lines 130
SQL> conn sysadm/password
Connected.
SQL> select instance_name,host_name,user from v$instance;
INSTANCE_NAME HOST_NAME USER
---------------- -------------------- ------------------------------
HCMINT2 st00srv01 SYSADM
SQL> select user from dual@dps_timesheet_mv;
USER
------------------------------
SYSADM
SQL> conn sysadm/password@hcmint2
Connected.
SQL> select instance_name,host_name,user from v$instance;
INSTANCE_NAME HOST_NAME USER
---------------- -------------------- ------------------------------
HCMINT2 st00srv01 SYSADM
SQL> select user from dual@dps_timesheet_mv;
select user from dual@dps_timesheet_mv