ORA-00942: table or view does not exist

Document ID : KB000054986
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

While trying to extract Oracle objects from an Oracle database using the AllFusion Repository Exchange for Oracle, one might receive the following error although this table (or view) definitely exists.

Figure 1

Clicking OK on this message will eventually lead to the following message.

Figure 2

Solution:

The user receiving this error is lacking the Oracle System Privilege 'SELECT_ANY_DICTIONARY'. Contact your DBA to have this privilege granted to your userid.