DDL / Remap Schema : ORA-942 Connected With DBMS_TABCOMP_TEMP_CMP & DBMS_TABCOMP_TEMP_UNCMP (Doc ID 1505178.1)

Last updated on MAY 16, 2017

Applies to:

Oracle GoldenGate - Version 11.1.1.1.0 to 11.2.1.0.3 [Release 11.1.1.1 to 11.2]
Information in this document applies to any platform.

Symptoms

Errors are being generated of the form :

2012-10-22 09:14:14 ERROR OGG-00519 Oracle GoldenGate Delivery for Oracle, RPTX00D1.prm: Fatal error executing DDL replication: error [Error code [942], ORA-00942: table or view does not exist, SQL
create table "<REMAPPED_SCHEMA>"."DBMS_TABCOMP_TEMP_UNCMP" tablespace "DATA" nologging as select /*+ DYNAMIC_SAMPLING(0) FULL("<SOURCE_SCHEMA>"."BATCH") */ * from "<SOURCE_SCHEMA>"."BATCH" sample block( 55.8) my], no error handler present.

The <SOURCE_SCHEMA> does not exist in the database where GoldenGate is applying changes .

Tables referenced which cannot be created are : DBMS_TABCOMP_TEMP_CMP and DBMS_TABCOMP_TEMP_UNCMP.

Changes

The Compression Advisor is now being used on objects which are being Captured by GoldenGate

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