Skip to Main Content

Oracle Database Discussions

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!

Database Links and Global_Names

1733700Sep 25 2014 — edited Oct 2 2014

Source DB is 10.2.0.5 with Global_Names=True

Target DB is 11.2.0.2. with Global_Names=False, DB_Domain and Global_Name are both Null

When creating the link in the Source, it appends the Domain to the name which causes the ORA-02085 error.

Is there a way to get this to work without setting DB_DOMAIN, GLOBAL_NAME, and GLOBAL_NAMES=TRUE on the Target DB? The Target DB has several other external customers that would be impacted if GLOBAL_NAMES is set to TRUE.

Thanks.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 30 2014
Added on Sep 25 2014
6 comments
1,732 views