Forum Stats

  • 3,782,457 Users
  • 2,254,650 Discussions
  • 7,880,082 Comments

Discussions

synonym not working

Comet
Comet Member Posts: 173 Blue Ribbon
edited Sep 25, 2008 3:57AM in APEX Discussions
The command:

SELECT * FROM [email protected]

Returns rows but I needed to create a synonym to simplify my application code.

I created a synonym named and FMDMMD the parameters I used are:

Synonym Name: FMSMMD
Public or Private: Private
Schema: MMD2
Object: DWEISTST2FMSSCO.ABC.GOV
Database Link: DWEISTST2FMSSCO.ABC.GOV

When I issue the command:

SELECT * FROM [email protected]

APEX displays the error message:

ORA-02019: connection description for remote database not found

When I created the sysnonym I did not know what to put in the Object property. How do I find out what the Object is for my synonym? I have privileges to create Private synonyms only. Do I need to request any information privileges from the DBA?
Tagged:

Answers

This discussion has been closed.