Home » Infrastructure » Other Operating Systems » Synonym for a synonym
Synonym for a synonym [message #101690] Wed, 20 March 2002 23:30 Go to next message
Messages: 2
Registered: March 2002
Junior Member
I have a synonym SYMA pointing to a table TABA.
I am trying to create another synonym SYMB pointing to SYMA, so as to query TABA in my program.

The CREATE command executes successfully. But I am getting the following error at program runtime for SYMB:
ORA-00942: table or view does not exist.

When I try to create a synonym for TABA directly, it works fine.

What am I doing wrong?

Re: Synonym for a synonym [message #101691 is a reply to message #101690] Mon, 25 March 2002 01:03 Go to previous messageGo to next message
Messages: 14
Registered: February 2002
Junior Member
why do you want to shoot by the chest in the eye?

Did you mix up private and public synonyms? Are there different users at program runtime? According to oracle documentation it must work.

Re: Synonym for a synonym [message #101753 is a reply to message #101690] Sat, 07 February 2004 12:31 Go to previous message
William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK
Senior Member
Synonyms can be created even when the object referred to does not exist. If you replace the synonym in your program with the actual object name, does it run OK? Can you DESCRIBE the synonym from SQL*Plus?

Does this have anything to do with VMS?
Previous Topic: VMS
Next Topic: SQL*Plus
Goto Forum:

Current Time: Mon Oct 18 19:08:43 CDT 2021