Resolve ORA-02085: database link connects to by

Resolve  ORA-02085: database link 

Error:  ORA-02085: database link <name> connects to by<> 

Cause: When parameter global_name set to TRUE you cannot create database link name different from database service name.

Solution : 
 Quick fix by: alter system set global_name=FALSE;

Thanks


No comments

2015@Bahaa Barghouti. Powered by Blogger.