CREATE PUBLIC DATABASE LINK OLD_LINK CONNECT TO LIVEDATA IDENTIFIED BY LIVEDATA USING LIFE.STARCORP.LOCAL';Then I connected the TESTDATA schema, and then tried the following query:
sql>SELECT * FROM DUAL@OLD_LINK;I got the following:
ERROR at line 1: ORA-02085: database link OLD_LINK.STARCORP.LOCAL connects to LIFE.STARCORP.LOCALPlease help me. Thanks in advance.
- The GLOBAL_NAMES initialization parameter is set to TRUE.
- The database name of the remote database does not match the database link name.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.