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 ) (Doc ID 1484499.1)

Last updated on SEPTEMBER 05, 2012

Applies to:

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

Symptoms

Replicat is using incorrect schema for replicating a DDL statement

eg.,

Following is done on source,

sqlplus Y1NR/Y1NR
> 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 [942], ORA-00942: table or view does not exist SQL drop table brand_new
  /* GOLDENGATE_DDL_REPLICATION */], no error handler present.

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