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 to [Release to 11.2]
Information in this document applies to any platform.


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.


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


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

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