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 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,

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.


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