Using Designer 10.1.2 RAU to Export a Repository in a 9i Database Fails with CDR-21245, ORA-942 (Doc ID 334478.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Repository - Version: 10.1.2
This problem can occur on any platform.
Repository Administration Utility
Export

Symptoms

Exporting a repository from the Repository Administration Utility (RAU) fails with:
   CDR-21245: The export may have failed.

The export log file contains the errors:
   EXP-00056: ORACLE error 942 encountered
   ORA-00942: table or view does not exist
   EXP-00000: Export terminated unsuccessfully

Versions:
   Designer Client: Oracle Designer 10g Release 2 Version 10.1.2.0.2
   Designer Repository: Oracle Designer 9i Release 9.0.2.8
   Database: RDBMS 9.2.0.5

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms