My Oracle Support Banner

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

Last updated on FEBRUARY 18, 2019

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, REPXXXX1.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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.