Skip to Main Content

SQL & PL/SQL

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!

recreating a DB link

DBQuestSep 18 2019 — edited Sep 18 2019

During investigation of issue we have identified that, DB link is pointing to TESTDB database instead of DEVDB database.

We want to correct db link to point DEVDB database, for this we need to drop and recreate the DB link or ALTER the DB link.

If we drop and recreate the DB link, all the synonyms using that DB links also will be dropped ?

Please advise.

Comments
Post Details
Added on Sep 18 2019
2 comments
1,532 views