HI Guys

Is there any way to know which userid is used to create a DB_LINK?

OWNER DB_LINK USERNAME HOST CREATED
---------- --------------------------------- ---------- ---------- -----------

PUBLIC NCP1_LINK_TK1.WORLD ncp1 11-MAR-1999

Until recently this link was working fine. Dont know what happend, the other day when I run the script to get count of records in the remote table we got this error.


SQL> SELECT COUNT(1) FROM VEFS_RMINDEX;
SELECT COUNT(1) FROM VEFS_RMINDEX
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from NCP1_LINK_TK1


SQL> SELECT COUNT(1) FROM VEFS_RMCA;
SELECT COUNT(1) FROM VEFS_RMCA
*
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from NCP1_LINK_TK1


SQL> SELECT COUNT(1) FROM VEFS_RMORG;
SELECT COUNT(1) FROM VEFS_RMORG
*
ERROR at line 1:
ORA-28000: the account is locked
ORA-02063: preceding line from NCP1_LINK_TK1


Your help is highly appreciated.

Regards
Bhaskara