Goldengate classic configuration does not support global temporary tables.
Does GOldenGate support replication of Global Temporary Table DDL replication? (Doc ID 1563450.1)
How To Enable Global Temporary Table DDL Replication In Goldengate? (Doc ID 2322955.1)
References:-
below is the demo done in my classic goldengate configuration system
SQL> create global temporary table us01.gt (id number);
SQL> drop table us01.gt;
Only create statement captured, and drop statement did not captured by OGG. you need to manually drop the table in target.
SQL> drop table us01.gt;
Only create statement captured, and drop statement did not captured by OGG. you need to manually drop the table in target.
Only integrated capture with integrated dictionary supports capture of DDLs which contain Global Temporary Tables but with limitation. For more information please refer below oracle support documents
How To Enable Global Temporary Table DDL Replication In Goldengate? (Doc ID 2322955.1)
References:-
http://www.dbaglobe.com/2012/05/oracle-global-temporary-table-not.html
Does GOldenGate support replication of Global Temporary Table DDL replication? (Doc ID 1563450.1)
How To Enable Global Temporary Table DDL Replication In Goldengate? (Doc ID 2322955.1)
How To Enable Global Temporary Table DDL Replication In Goldengate? (Doc ID 2322955.1)
No comments:
Post a Comment