Toad World® Forums

dblink


#1

Part of this sql is to get data from a table on a different oracle server named wicked:

left outer join (select a.* FROM ibdd_caspr.ts_new_loan_prod_fact@wicked a

The error that I get is invalid username/password.

How do I login to the Wicked server in order to use this dblink?

The full sql is attached.

test sql for Toad.sql (2.89 KB)


#2

Hi Jonathan,

Part of this sql is to get data from a table on a different oracle
server named wicked:

left outer join (select a.* FROM ibdd_caspr.ts_new_loan_prod_fact@wicked a

The error that I get is invalid username/password.

How do I login to the Wicked server in order to use this dblink?

The full sql is attached.

There are two ways that a database link can be used. The first has it
connecting directly to a given user name and password. The second is not
to specify a user name and password when creating the link. In this
latter case, the user name and password default to that of the account
actually using the link.

So, your problem is to determine if the link has been set up at some
point whit or without a user name and password and if the former, alter
the link to set the correct password and/or user name.

In the case of the latter, you need to be logged into a user on “this”
database that matches one on the remote (wicked) database.


Cheers,
Norm. [TeamT]


#3

Hello jonathan.beckloff_171,

Part of this sql is to get data from a table on a different oracle server
named wicked:
left outer join ( select a .* FROM ibdd_caspr .
ts_new_loan_prod_fact@wicked a

The error that I get is invalid username/password.

How do I login to the Wicked server in order to use this dblink?

With the information you’ve given, the best answer is: “See your DBA.”

See also (in this order):

 http://tahiti.oracle.com
 http://supporthtml.oracle.com

On the above websites search for:

 "database link"

with the quotes.

Good luck!

Rich – [TeamT]

Disclaimer: Stiffed on POY, COY, and ProBowl nods, it’s all about The Grudge.