OGG v11.2 extract writes incorrect session schema name in to the trails causing replicat to fail on DDL operations (ORA-00942: table or view does not exist )
Last updated on SEPTEMBER 05, 2012
Applies to:Oracle GoldenGate - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
Replicat is using incorrect schema for replicating a DDL statement
Following is done on source,
> drop table brand_new;
Replicat tries to drop the table on SYS instead of Y1NR
2012-07-12 15:05:45 INFO OGG-01407 Setting current schema for DDL operation to [SYS].
2012-07-12 15:55:05 ERROR OGG-00519 Fatal error executing DDL replication: error [Error code , ORA-00942: table or view does not exist SQL drop table brand_new
/* GOLDENGATE_DDL_REPLICATION */], no error handler present.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms