Database Links: Troubleshooting ORA-2085: database link %s connects to %s
(Doc ID 210630.1)
Last updated on JUNE 21, 2023
Applies to:Oracle Net Services - Version 18.104.22.168 and later
Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
This document describes creating database links and troubleshooting the ORA-2085 error that might occur during a select across the dblink.
To explain database link naming rules in an effort to avoid the error ORA-2085 "database link %s connects to %s". Additionally, the effect of GLOBAL_NAMES=TRUE on the creation and use of database links. The naming rules that are described in this note are not applicable when GLOBAL_NAMES=FALSE.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!