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:
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';
in query:
create database link APPS_TO_APPS connect to APPS identified by using 'DEV';
you have not specified password.
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.
Post a Comment