Creation of a Loopback DBLINK Yields the Error: ORA-2082
Last updated on AUGUST 06, 2014
Applies to:Oracle Net Services - Version 220.127.116.11 to 18.104.22.168 [Release 9.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 7-aug-2014***
this note does not seem to apply for 12c
During the creation of a loopback database link the following error is thrown and the link is not created:
Cause: An attempt was made to create a database link with the same name as
the current database.
In some newer releases of Oracle, the following error may be thrown in addition to the ORA-2082:
This is a new attempt to create a database link that loops back to itself.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms