In sweet memories of my ever loving brother "kutty thambi " ARUN KUMAR

Wednesday, December 19, 2018

Global temporary tables in goldengate configuration

Goldengate classic configuration does not support global temporary tables.

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. 

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

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:-
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)

No comments:

free counters
 
Share/Bookmark