Error: "ORA-00942: table or view does not exist". (4259004)

Error received in the declt log during compare:

"000: OS Version : SunOS 5.8 Generic_117350-24
000: Machine : sun4u
000: Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production
000: Key Compare : Off
000: Oracle Error: ORA-00942: table or view does not exist

000: Error 942 calling oexfet in de_table_ask_obj_id
000: Error 1 calling de_table_ask_obj_id in de_repair_setup
000: Error 1 calling de_repair_setup in main
Exiting"

Shareplex database User lacks permission to view dictionary information.

RESOLUTION:

1. Grant 'Select Any Dictionary' to the Shareplex Database User on the Source and Target:

For 9i Databases:

GRANT SELECT ANY DICTIONARY TO SPLEX;

For 8i Databases:

GRANT SELECT_CATALOG_ROLE TO SPLEX;

OR

2. Modify the Oracle init.ora file to set the Parameter O7_DICTIONARY_ACCESSIBILITY to TRUE, then bounce database. For Oracle 9i Databases, this parameter is set to FALSE by default.

3. Run the Compare.