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 ??