When I go to Database | Export | Export DDL | click "Add" button | click on "Search for Database Objects" button (green play icon) will generate the error: ORA-00942 - Table or View does not exist.
When "Check for Access to DBA Views" in the Toad Options is un-checked, Toad queries SYS.ALL_JOBS instead of just ALL_JOBS.
ALL_JOBS is owned by Public, not the SYS schema. So having ALL_JOBS prefixed with SYS (i.e. SYS.ALL_JOBS) will not work. ALL_JOBS does not exist at all in the SYS schema.
WORKAROUND 1:
Go to View Menu | Toad Options | Startup | check mark "Check for Access to DBA Views" | click OK | and then exit and restart Toad. NOTE: Additional privileges might be needed for your user.
WORKAROUND 2:
Un-check "JOB" under "Search Object Names" list. The location of this is in Database | Export | Export DDL | click "Add" button | middle part of the Object Search Window.
STATUS:
Waiting for fix in a future release of Toad for Oracle.
