The Session Browser keeps up bringing up ORA-00980: synonym translation is no longer valid when running
a query.
ORA-00980: synonym translation is no longer valid
Cause: The synonym used is based on a table, view, or synonym that no longer exists.
Action: Replace the synonym with the name of the object it references or re-create the synonym so that it refers to a valid table, view, or synonym.
The following public synonyms must be present for the Session Browser to work:
V$SESSION
V$PROCESS
V$SESS_IO
V$SESSION_WAIT
V$SESSION_EVENT
V$ACCESS
V$SESSSTAT
V$STATNAME
V$OPEN_CURSOR
V$SQL
V$LOCK
V$SESSION_LONGOPS
V$SQLTEXT_WITH_NEWLINES
In addition, you must have access to the following:
SYS.V_$TRANSACTION
SYS.V_$ROLLNAME
Rerun the server side objects for the TOAD Explain Plan under Tools > Server Side Object Wizard.
