Return
-
Title
Error: "ORA_00942 table or view does not exist" when extracting a DDL for a user. -
Description
Error received when extracting a DDL for one table, however,the table columns can be viewed in the left hand panel:
"ORA-00942 table or view does not exist" -
Resolution
The grant select any Dictionary:
GRANT SELECT ANY DICTIONARY TO <username>; -
Additional Information
The grant - GRANT SELECT ANY TABLE TO <username> is done but it has had no affect.