winona
1
Hi,
i am trying to access data from database to another in Toad through a simple SQL statement.
select * from sysadm.ps_fz_audit_table@fs9tst
fs9tst is my test server, but i get the below error.
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from FS9TST
That means that your database link fs9tst is not set up with the right username and password.
for testing db_links always use query simple as possible. Example:
select 1 from dual@fs9tst;
If that doesn’t work then db_link is not defined well.
If this pass then you might have problem with select right on specific table.
winona
4
I think i am required to maintain the same password in both dev and test , i did that after which i am able to fetch data from other database.
Having the same password for dev and test could lead to accidental connections to the wrong database. Be careful.