Re: Verifying links..

You want an anonymous database link -- a user automatically links to their same userid on the other database. I believe the syntax is something like:

CREATE PUBLIC DATABASE LINK dbname USING 'dbname';

Carlos Jofre Jr. wrote in message <36827B04.F59A44A6_at_gate.net>...
>Hello,
>
>I am currently writting an application to automatically load data form
>one
>instance to another. We have links set up across the two. I have been
>asked to
>check for the status of the link PRIOR to running any PL/SQL stuff.
>
>They need to know when the links maybe down.. and alert the appropriate
>people.
>
>Has anyone out there done this WITHOUT having to specify a user/password
>when connecting to the DB.
>Due to security issues, they do not want to see a script out there with
>a production password in it...
>
>I have been successful with a script that does contain the user/password
>so
>I may end up doing this anyway, and giving the prod user rwx------
>access to this script. That is, if there is not other way...
>Environment:
>UNIX HP-UX B.10.20/ ORACLE7 7.3.3.5.1
>
>All the best!
>
>C. Jofre.
>
>
Received on Mon Dec 28 1998 - 23:20:36 CST