Error: "ORA-00942 table or view does not exist" when trying to change the current schema view.
说明
Error: "ORA-00942 table or view does not exist" when trying to change the current schema view. This happens when access rights have been implemented in Schemas
原因
The logged in user needs Select dictionary privileges to be able to view other schemas.
解决办法
RESOLUTION: Grant dictionary privileges to the user and check that the SQL Navigator option General | Session | "Enable using DBA dictionary views" is enabled/checked off.
