APEX

The command:

SELECT * FROM PO_HEADERS_ALL@DWEISTST2FMSSCO.ABC.GOV

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 PO_HEADERS_ALL@FMSSCO

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?