Skip to Main Content

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!

Change Host in DB link

DBQuestSep 18 2019 — edited Sep 19 2019

Currently my DB link is pointing to incorrect database CIS1D, 

CREATE DATABASE LINK "hrms_sales_db_link"

CONNECT TO sales_user

IDENTIFIED BY <password>

USING 'CIS1D';

I want to make my db link hrms_sales_db_link should be point to CIS2D instead of CIS1D.

I need to Alter the db link or drop and recreate db link to point to correct host??  Please advise.

If I drop or alter what will happens to all the synonyms created based on db link hrms_sales_db_link ??

This post has been answered by Adityanath Dewoolkar on Sep 18 2019
Jump to Answer
Comments
Post Details
Added on Sep 18 2019
3 comments
13,063 views