Database Administration (MOSC)

MOSC Banner

Need to find DB link

edited May 27, 2014 12:00PM in Database Administration (MOSC) 10 commentsAnswered

Hi,

I have executed below SQL query and getting error due to DB link issue

/*

SQL> select * from xxbel_inv_pincode;
select * from xxbel_inv_pincode
              *
ERROR at line 1:
ORA-12154: TNS:could not resolve the connect identifier specified


SQL> spool off;

*/

Due to DB link issue above table is not executed. How to find such DB link.

Regards,

Madhu

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