DDL / Remap Schema : ORA-942 Connected With DBMS_TABCOMP_TEMP_CMP & DBMS_TABCOMP_TEMP_UNCMP
Last updated on MAY 16, 2017
Applies to:Oracle GoldenGate - Version 18.104.22.168.0 to 22.214.171.124.3 [Release 126.96.36.199 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, RPTX00D1.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
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