TIP #10: How to find password of existing database link

I faced with a odd situation.I `d like to copy some databases link from source DBs to target DBs. In order to create database link in target database, I decided to run "create database link" sql statement.However, for creating database link in target database, I need to know username and password which is currently used by the existing database link in source database.

sys.link$ has unencrypted password value for each database link.

The following is sample query.


select 'create database link ' || name ||' connect to '|| userid ||' identified by ' || password || ' using '||''''||host ||''''||';' from sys.link$

3 comments:

Eduardo said...

Hi,

I'm using your script to get dblink's password but in the output im not getting the passowrd, any idea why?

create database link APPS_TO_APPS connect to APPS identified by using 'DEV';

Anonymous said...

in query:
create database link APPS_TO_APPS connect to APPS identified by using 'DEV';

you have not specified password.

Raj said...

Hi,

Thanks for sharing the information.
I executed above command from our database but we are also getting result as below.

create database link SCOTT_DB_LINK connect to TEST identified by using 'TEST';

In this case password is showing for empty. How to find the source schema password?

please guide me.