When in the Schema Browser and then selecting "Create Script" or going to "Script" tab on the right-side, Toad gives the following error:
"ORA-00942: table or view does not exist"
Oracle privileges or missing table\view.
The Export DDL or 'Create Script' option queries different tables\views in Oracle and there may be additional permissions required to access these system objects.
To review what Toad is running and what is causing the error, enable SQL Tracker while performing the script actions to get an output of where the error occurs:
1. Launch and connect Toad.
2. Enable SQL Tracker by going to Database | Monitor | SQL Tracker.
The SQL Tracker window will open
3. Select the session of 'toad.exe' you are working with and click the green arrow button to start monitoring that session.
4. Go back to Toad, and replicate the issue, till it errors out.
5. Go back to SQL Tracker and check what SQL was collected.
The query that causes the error, and the error message itself should display in the log on the Tracker window.
To verify the SQL and error, attempt to run the query alone in SQL Plus:
a. If the error occurs then check to see if the table\view exists where the query is invoking.
b. If the table\view exists, please check with your Oracle DBA for proper privileges to access the table\view.
c. If the table\view does not exist, check with your Oracle DBA to re-build the object.