ORA-00942: table or view does not exist

Products

• Repository

Issue/Introduction

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.

<Please see attached file for image>

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

<Please see attached file for image>

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.

Environment

Release:
Component: XOR