Toad for Oracle error when I click on the Explain Plan icon: "Explain Plan Error: ORA-00942: table or view does not exist."
A script is run on startup of Toad which sets or alter the session to a different schema. However, right after the first run of an Explain Plan, Toad always issue another alter set schema back to the currently logged in user/schema. That is why the error occurs. Why is there another command run that resets the user setting for the session? How can this be disabled?
WORKAROUND:
None
STATUS:
Waiting for fix in a future release of Toad for Oracle.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center