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 188.8.131.52.0 to 184.108.40.206.3 [Release 220.127.116.11 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 , 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