I have a linked server called DOA_FANS on my SQL 2012 that connects to an Oracle server/database. One of the tables in Oracle is called FIS.TITLE.CONTRACTS I can use this and read the table: SELECT * FROM OPENQUERY(DOA_FANS,'Select * from FIS.TITLE_CONTRACTS'). I was asked to create a synonym called FTC so that the query could be shorter. I executed this command:
CREATE SYNONYM FTC
and it said it executed successfully. However, when I try SELECT * FROM FTC I get a error msg 5313 that says Synonym 'FTC' refers to an invalid object.
I checked sys.synonyms and it is there. I have seen several posts online that this should work, but it isn't.