DBA_GOLDENGATE_SUPPORT_MODE

DBA_GOLDENGATE_SUPPORT_MODE displays information about the level of Oracle GoldenGate capture process support for the tables in the database.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(128)		Table owner
OBJECT_NAME	VARCHAR2(128)		Table name
SUPPORT_MODE	VARCHAR2(6)		Capture process support level for the table: FULL - A capture process can capture changes made to all of the columns in the table ID KEY - A capture process can capture changes made to the key columns and any other columns in the table supported by the capture process, except for LOB, LONG, LONG RAW, and XMLType columns. PLSQL - A capture process can capture changes made to the table as long as Procedural Supplemental Logging is enabled on the source database. Such tables include hierarchy-enabled tables, AQ queue tables, and tables containing columns of type MDSYS.SDO_TOPO_GEOMETRY, MDSYS.SDO_GEORASTER, or MDSYS.SDO_RDF_TRIPLE_S. NONE - A capture process cannot capture changes made to any columns in the table because the table is not supported for replication.
EXPLANATION	VARCHAR2(4000)		Reason the table does not have FULL capture process support This column is populated only when both of the following conditions are met: The value of the COMPATIBLE initialization parameter is 20.0 or higher The value of the SUPPORT_MODE column is ID KEY, INTERNAL, PLSQL, or NONE
LOGICAL_REPLICATION	VARCHAR2(8)		Indicates whether logical replication is ENABLED or DISABLED for the table
AUTO_CAPTURE	VARCHAR2(8)		Indicates whether automatic capture is ENABLED or DISABLED for the table
ALL_KEYS	VARCHAR2(3)		Indicates whether ALL KEYS supplemental logging is enabled for the table (YES) or not (NO)
ALL_COLS	VARCHAR2(3)		Indicates whether ALL COLUMN supplemental logging is enabled for the table (YES) or not (NO)
OTHER_KEYS	VARCHAR2(3)		Indicates whether other key column supplemental logging, such as primary key, foreign key, unique index, or log group, is enabled for the table (YES) or not (NO)