GoldenGate 12.2 DDL Replication For User Creation Fails. Source Is 12.1.0.2.0 DB Target Is 11,.2.0. (Doc ID 2165631.1)

Last updated on JANUARY 05, 2017

Applies to:

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

Symptoms

Source: Oracle 12c RDBMS with OGG 12.2*
Target: Oracle 11g RDBMS with OGG 12.2*

1. Source DDL: create user amal identified by amal;

2. Oracle stores following in the log:
create user amal identified by VALUES 'S:90AB955F0593C60525FB016B28E4234E61590C 9CBCD6409EBE8A56CDF566;H:ABBBC81D2C45F4B13F67619B04125A5C;T:2D4A1118EBF368B6E1BD 0C1AA1950C00E90890800B325AFCA5A37172146ADEC0661F19240F98D6AADD5BCD467C4868CF22ED 238E2628929D71F2BF88978D34A79E28EA290DC39D673DB252BA11F78ECF;76A00B1DEFF57F35' ;

3. Goldengate reads from Oracle log and tries to apply the same on target and fails:
2016-05-12 16:20:49 ERROR OGG-00519 Fatal error executing DDL replication: error [Error code [972], ORA-00972: identifier is too long SQL /* GOLDENGATE_DDL_REPLICATION */ create
user amal identified by VALUES 'S:90AB955F0593C60525FB016B28E4234E61590C9CBCD6409EBE8A56CDF566;H:ABBBC81D2C45F4B13F67619B04125A5C;T:2D4A1118EBF368B6E1BD0C1AA1950C00E90890800B325AFCA5
A37172146ADEC0661F19240F98D6AADD5BCD467C4868CF22ED238E2628929D71F2BF88978D34A79E28EA290DC39D673DB252BA11F78ECF;76A00B1DEFF57F35' /* GOLDENGATE_DDL_REPLICATION */], no error handler present.

--Reason Maximum the identifier is greater than 30 characters, Oracle RDBMS limitation.

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