DDL Replication failed with ORA-01741: illegal zero-length identifier
edited Jun 25, 2018 4:05PM in GoldenGate, Streams and Distributed Database (MOSC) 8 commentsAnswered
Hello,
I have setup DDL replication.
When I try to test the DDL replication by creating a table on source that create table flowed to the target but failed with the below errors...
I am not sure if it is a BUG or a mistake in parameter file.
GG version: 11.1.1.0.29
DB version: 11.1.0.7
I have setup DDL replication.
When I try to test the DDL replication by creating a table on source that create table flowed to the target but failed with the below errors...
I am not sure if it is a BUG or a mistake in parameter file.
GG version: 11.1.1.0.29
DB version: 11.1.0.7
2013-01-25 06:39:34 INFO OGG-00482 Oracle GoldenGate Delivery for Oracle, rp1c157a.prm: DDL found, operation [CREATE TABLE golden.ab ( id NUMBER PRIMARY KEY, name VARCHAR2(30)) (size 89)].
2013-01-25 06:39:34 INFO OGG-00489 Oracle GoldenGate Delivery for Oracle, rp1c157a.prm: DDL is of mapped scope, after mapping new operation [CREATE TABLE "GGS"."" ( id NUMBER PRIMARY KEY, name VARCHAR2(30)) (size 88)].
0