-
标题
ORA-20001: ORA-00995: missing or invalid synonym identifier when executing 'drop synonym ' -
说明
SQLab Vision
Receiving the following error message while granting a NUMERICAL name NON DBA database user with the SQLab role.
ORA-20001: ORA-00995: missing or invalid synonym identifier when executing 'drop synonym 926474.QUEST-SL_ALL_INDEX_COLUMNS' (926474 is the numerical user name)
ORA-06512: at "QUEST_DEV.QUEST_SL_USER_MANAGER", line 35
ORA-06512: at "QUEST_DEV.QUEST_SL_USER_MANAGER", line 68
ORA-06512: at "QUEST_DEV.QUEST_SL_USER_MANAGER", line 220
ORA-06512: at line 2 -
解决办法
WORKAROUND
Please use the patch to handle this issue.
This patch allows users such as "12345" to be configure to use SQLab. This fix will NOT be in the next GA release (4.7.1).
This is a special stand alone patch.
STATUS
This will be fixed in future release following SQLab Vision 4.7.1.