How do I get the password when doing a create database link?

Hi,

I created a script for a Create Database Link for an Oracle 9I database. I want to move this Create to an Oracle 11g database. The script has an "Identified by " which usually comes up with a string of numbers but didn’t in this case. Could someone tell me where I go to get the password value?

Thanks, Roy

In the script options, there is a checkbox for “If possible, include “identified by values” clause in 11g and newer.”

Make sure this is checked. In 11g and newer, you can only get the password if you have the SELECT privilege on the SYS.USER$ table. The password is no longer present in DBA_USERS.