Replicat Not Applying "ALTER TABLE RENAME NEWTABLE"
(Doc ID 2125057.1)
Last updated on JUNE 29, 2023
Applies to:
Oracle GoldenGate - Version 12.1.2.1.0 and laterInformation 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.
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
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 |
Cause |
Solution |