Oracle DB Error ORA-00995 missing or invalid synonym identifier

The following in the cause of this error:

In a CREATE or DROP SYNONYM statement, the synonym name was either missing or invalid.

Action you can take to resolve this issue: Check syntax and spelling. A valid synonym name must be specified immediately following the keyword SYNONYM in both statements. Valid synonym names must begin with a letter, consist of alphanumeric characters and the special characters $, _, and #, and be less than or equal to 30 characters. They may not be reserved words.

Tags: Database, Education, Software

Related