Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create or Replace DB link command.

846231Sep 12 2012 — edited Sep 12 2012

Hi all,

Ora 11.2.0.1 Windows Server 2003

Is there such a CREATE OR REPLACE DATABASE LINK command?

We have lots of Developement databases and our central TNSNAMES.ORA is constantly changing. This is because some database are decommissioned, or newly added, or migrated to other servers.
In this regard, I have a central monitoring database tool that creates dblink connecting to all the databases listed in the TNSNAMES.ORA.
So when there a new db added I will create new dblink. If there is decommissioned I will drop the dblink. If there is migrated I will create or replace db link.

How can I automate or manage this creation of database link but just by reading the TNSNAMES.ORA as input? Any bright ideas please.....

Please help....

Thanks a lot,
Kinz

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 10 2012

Added on Sep 12 2012

#general-database-discussions

2 comments

4,269 views