When describing a view / public synonym, the message "View SCHEMA.OBJECT_NAME does not exist" appears in the Describe window.
Steps to replicate:
Connect as USER1
- Run:
CREATE OR REPLACE VIEW V_TEST AS SELECT 1 TEST FROM DUAL;
CREATE PUBLIC SYNONYM V_TEST FOR V_TEST;
Connect as USER2
- Ensure that the option Editor | Display | 'Highlight view names' is active
- Open a SQL Editor
- Type V_TEST and hit F4. The view is described as expected
- Open the Schema browser
- Change the user dropdown to be that of USER1
- Open the Views tab and search for the view V_TEST. The view is displayed as expected
- Go back to the Editor. View is now "known" and highlighted
- Press F4 again
The Describe dialog window opens, empty, with error "View USER2(!).V_TEST does not exist".
WORKAROUND:
Type the view name in user 2 Editor as: USER1.VIEW_NAME
STATUS:
Waiting for fix in a future release of Toad for Oracle
