Thursday, May 10, 2012

Oracle global temporary table not supported by OGG 11.2

SQL> create table global temporary table bbadmin.gt (id number);


SQL> drop table bbadmin.gt;

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.