Replicat Not Applying "ALTER TABLE RENAME NEWTABLE" (Doc ID 2125057.1)

Last updated on APRIL 07, 2016

Applies to:

Oracle GoldenGate - Version 12.1.2.1.0 and later
Information in this document applies to any platform.

Symptoms

Replicat is abending with the following:


 Oracle GoldenGate Delivery for Oracle
 Version 12.1.2.1.11 21831216 OGGCORE_12.1.2.1.0OGGBP_PLATFORMS_151121.0201.1_FBO

ALTER TABLE "CYCLE" RENAME TO "PH1M_CYCLE" (size 165)].

2016-03-31 20:15:29 INFO OGG-00487 DDL operation included [INCLUDE ALL], optype [ALTER], objtype [TABLE], objowner [ALMA], objname [PH1M_CYCLE].

2016-03-31 20:15:29 INFO OGG-01407 Setting current schema for DDL operation to [ALMA].

2016-03-31 20:15:29 INFO OGG-00484 Executing DDL operation.

2016-03-31 20:15:29 INFO OGG-00492 DDL error ignored: error code [DEFAULT], filter [include all (default)], error text [Error code [3001], ORA-03001: unimplemented feature SQL

/* rename ph1m tables, and create views with the old names */
ALTER TABLE "CYCLE" RENAME TO "PH1M_CYCLE""ALMA"."CYCLE"


ALTER TABLE "CYCLE" RENAME TO "PH1M_CYCLE" /* GOLDENGATE_DDL_REPLICATION */].

2016-03-31 20:15:29 INFO OGG-01408 Restoring current schema for DDL operation to [OGGADM].

2016-03-31 20:15:29 INFO OGG-00482 DDL found, operation [
CREATE VIEW "CYCLE" AS SELECT * FROM "PH1M_CYCLE" (size 50)].

2016-03-31 20:15:29 INFO OGG-00489 DDL is of mapped scope, after mapping new operation [
CREATE VIEW "ALMA"."CYCLE" AS SELECT * FROM "PH1M_CYCLE" (size 57)].

2016-03-31 20:15:29 INFO OGG-00487 DDL operation included [INCLUDE ALL], optype [CREATE], objtype [VIEW], objowner [ALMA], objname [CYCLE].

2016-03-31 20:15:29 INFO OGG-01407 Setting current schema for DDL operation to [ALMA].

2016-03-31 20:15:29 INFO OGG-00484 Executing DDL operation.

Source Context :
  SourceModule : [ggapp.ddl]
  SourceID : [/scratch/mmar/view_storage/mmar_21831216_lin64/oggcore/OpenSys/src/gglib/ggapp/ddlrep.c]
  SourceFunction : [DDLREP_handleDDLError]
  SourceLine : [811]
  ThreadBacktrace : [15] elements
  : [/u01/app/gg/12.1.2/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f812f52226e]]
  : [/u01/app/gg/12.1.2/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x340) [0x7f812f51cf80]]
  : [/u01/app/gg/12.1.2/libgglog.so(_MSG_ERR_DDL_ABEND_NOT_INCLUDED(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x31) [0x7f812f506f2b]]
  : [/u01/app/gg/12.1.2/replicat(DDLREP_handleDDLError(ggs::gglib::ggunicode::UString const&, ggs::gglib::ggunicode::UString const&, bool, ggs::gglib::ggunicode::UString const&, ggs::gglib::ggunicode::UString&, int, RepConfig_t*, ggs::gglib::ggunicode::UString const&, ggs::gglib::ggunicode::UString const&, ggs::gglib::ggunicode::UString const&, ggs::gglib::ggapp::CDBObjName<(DBObjType)8>&, ggs::gglib::ggapp::CDBObjName<(DBObjType)7>&, ggs::gglib::ggapp::CDBObjName<(DBObjType)1>&, long*)+0xea7) [0x60b865]]
  : [/u01/app/gg/12.1.2/replicat [0x6115b3]]
  : [/u01/app/gg/12.1.2/replicat(DDLREP_process(char*, __std_rec_hdr*, unsigned short)+0x1f00) [0x614ff6]]
  : [/u01/app/gg/12.1.2/replicat(replicate_io(file_def*, __std_rec_hdr*, char*, extr_ptr_def*, int*, int)+0x26a7) [0x5c8217]]
  : [/u01/app/gg/12.1.2/replicat(process_replicat_loop()+0x1ead) [0x5aabcd]]
  : [/u01/app/gg/12.1.2/replicat(replicat_main(int, char**)+0x5d2) [0x5c2f42]]
  : [/u01/app/gg/12.1.2/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x4f) [0x6973af]]
  : [/u01/app/gg/12.1.2/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x104) [0x6976e4]]
  : [/u01/app/gg/12.1.2/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x8b) [0x6977eb]]
  : [/u01/app/gg/12.1.2/replicat(main+0x3f) [0x5c1bcf]]
  : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x3bc601d9f4]]
  : [/u01/app/gg/12.1.2/replicat [0x50f739]]

2016-03-31 20:15:29 ERROR OGG-00517 Fatal error executing DDL replication: error [Error code [942], ORA-00942: table or view does not exist SQL
CREATE VIEW "ALMA"."CYCLE" AS SELECT * FROM "PH1M_CYCLE" /* GOLDENGATE_DDL_REPLICATION */], because it's not included in error handling.

 

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