Thursday, May 10, 2012

Oracle global temporary table not supported by OGG 11.2

SQL> create table global temporary table (id number);

SQL> drop table;

Only first statement captured, and drop statement did not captured by OGG.

document [Does GoldenGate Support Replicating Temporary Tables? (Doc ID 1451424.1)] stating the replication of global temporary tables is not supported.

No comments:

Post a Comment