OGG Version 11.1.1.1 and Higher Creates AQ$_OGGQT$* Objects in OGG Schema (Doc ID 1364348.1)

Last updated on OCTOBER 09, 2013

Applies to:

Oracle GoldenGate - Version 11.1.1.1.0 and later
Information in this document applies to any platform.

Goal

Goal is to understand why Oracle GoldenGate (OGG) version 11.1.1.1 and higher creates AQ$_OGGQT$* objects in OGG schema

SQL> select object_name from dba_objects where owner='GGUSER' and object_name
like '%AQ$_OGG%';

AQ$_OGGQT$_E1AEE38035_Y
AQ$_OGGQT$_E1AEE38035_V
AQ$_OGGQT$_E1AEE38035_T
AQ$_OGGQT$_E1AEE38035_S

 

Solution

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