Database Administration (MOSC)

MOSC Banner

ORA-12154 error when using database link

edited Apr 16, 2013 10:35AM in Database Administration (MOSC) 7 commentsAnswered
I'm unable to retrive data using the database link. Can someone help please?

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center