Oracle DBMS_GOLDENGATE_ADM
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news. There is absolutely not a byte of truth to these irresponsible rumors.
Purpose Provides interfaces to configure automatic conflict detection and resolution in an Oracle GoldenGate configuration that replicates tables between Oracle databases. When more than one replica of a table allows changes to the table, a conflict can occur when a change is made to the same row in two different databases at nearly the same time. Oracle GoldenGate replicates changes using row logical change records (LCRs). It detects a conflict by comparing the old values in the row LCR with the current values of the corresponding table row identified by the key columns. If any column value does not match, then there is a conflict. After a conflict is detected, Oracle GoldenGate can resolve the conflict by overwriting values in the row with some values from the row LCR, ignoring the values in the row LCR, or computing a delta to update the row values.
AUTHID CURRENT_USER
Constants
Name Data Type Value
use_custom_handlers_none BINARY_INTEGER 0
use_custom_handlers_all BINARY_INTEGER 1
Dependencies
ALL_GG_AUTO_CDR_TABLES DBMS_GOLDENGATE_ADM_INT_IVOK DBMS_UTILITY
DBMS_APPLY_ADM DBMS_LOGREP_UTIL V$DATABASE
DBMS_ASSERT DBMS_STANDARD V$PARAMETER
DBMS_GOLDENGATE_ADM_INTERNAL    
Documented Yes
First Available 12.2.0.1
Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role and GGSYS.

Security on this package can be controlled either by granting EXECUTE on this package to selected users or roles or by granting EXECUTE_CATALOG_ROLE to selected users or roles.

If subprograms in the package are run from within a stored procedure, then the user who runs the subprograms must be granted EXECUTE privilege on the package directly. It cannot be granted through a role. An Oracle GoldenGate administrator must be configured at each Oracle database in the table’s replication environment, and Oracle GoldenGate must be configured to replicate the table at each Oracle database. You can configure an Oracle GoldenGate administrator using the GRANT_ADMIN_PRIVILEGE procedure in the DBMS_GOLDENGATE_ADM package.
Source {ORACLE_HOME}/rdbms/admin/dbmsgg.sql
Subprograms
 
ADD_AUTO_CDR (new 12.2)
Configure GoldenGate automatic conflict detection and resolution at the table level dbms_goldengate_adm.add_auto_cdr(
schema_name             IN VARCHAR2,
table_name              IN VARCHAR2,
resolution_granularity  IN VARCHAR2                 DEFAULT 'ROW',
existing_data_timestamp IN TIMESTAMP WITH TIME ZONE DEFAULT NULL,
tombstone_deletes       IN BOOLEAN                  DEFAULT TRUE,
fetchcols               IN BOOLEAN                  DEFAULT TRUE,
record_conflicts        IN BOOLEAN                  DEFAULT FALSE,
use_custom_handlers     IN BINARY_INTEGER           DEFAULT 0);
exec dbms_goldengate_adm.alter_auto_cdr_column_group('UWCLASS', 'SERVERS', '???', ???, TRUE, TRUE, TRUE); ???
 
ADD_AUTO_CDR_COLUMN_GROUP (new 12.2)
Adds a column group and configures  GoldenGate automatic conflict detection and resolution for the column group dbms_goldengate_adm.add_auto_cdr_column_group(
schema_name             IN VARCHAR2,
table_name              IN VARCHAR2,
column_list             IN VARCHAR2,
column_group_name       IN VARCHAR2                 DEFAULT NULL,
existing_data_timestamp IN TIMESTAMP WITH TIME ZONE DEFAULT NULL);
exec dbms_goldengate_adm.alter_auto_cdr_column_group('UWCLASS', 'SERVERS', 'LATITUDE,LONGITUDE', 'POSITION_COLGRP'); ???
 
ADD_AUTO_CDR_DELTA_RES (new 12.2)
Configures CDR and delta resolution for the column dbms_goldengate_adm.add_auto_cdr_delta_res(
schema_name IN VARCHAR2,
table_name  IN VARCHAR2,
column_name IN VARCHAR2);
exec dbms_goldengate_adm.alter_auto_cdr_delta_res('UWCLASS', 'SERVERS', 'STATUS');
 
ALTER_AUTO_CDR (new 12.2)
Alter automatic conflict detection and resolution at the table level dbms_goldengate_adm.alter_auto_cdr(
schema_name         IN VARCHAR2,
table_name          IN VARCHAR2,
tombstone_deletes   IN BOOLEAN        DEFAULT NULL,
fetchcols           IN BOOLEAN        DEFAULT NULL,
record_conflicts    IN BOOLEAN        DEFAULT NULL,
use_custom_handlers IN BINARY_INTEGER DEFAULT NULL);
exec dbms_goldengate_adm.alter_auto_cdr('UWCLASS', 'SERVERS', tombstone_deletes=>TRUE);
 
ALTER_AUTO_CDR_COLUMN_GROUP (new 12.2)
Alters a column group for automatic conflict detection and resolution dbms_goldengate_adm.alter_auto_cdr_column_group(
schema_name        IN VARCHAR2,
table_name         IN VARCHAR2,
column_group_name  IN VARCHAR2,
add_column_list    IN VARCHAR2,
remove_column_list IN VARCHAR2);
exec dbms_goldengate_adm.alter_auto_cdr_column_group('UWCLASS', 'SERVERS', '???', '???', '???');
 
DELETE_PROCREP_EXCLUSION_OBJ (new 12.2)
Deletes a database object from the exclusion list for GoldenGate procedural replication dbms_goldengate_adm.DELETE_PROCREP_EXCLUSION_OBJ(
package_owner IN VARCHAR2 DEFAULT NULL,
package_name  IN VARCHAR2 DEFAULT NULL,
object_owner  IN VARCHAR2 DEFAULT NULL,
object_name   IN VARCHAR2 DEFAULT NULL);
exec dbms_goldengate_adm.delete_procrep_exclusion_obj('UWCLASS', '???', 'UWCLASS', '???');
 
GG_PROCEDURE_REPLICATION_ON (new 12.2)
Returns 1 if GoldenGate procedural replication is enabled: 0 if disabled dbms_goldengate_adm.gg_procedure_replication_on RETURN NUMBER;
BEGIN
  IF dbms_goldengate_adm.gg_procedure_replication_on = 1 THEN
    dbms_output.put_line('Replication Is On');
  ELSE
    dbms_output.put_line('Replication Is Off');
  END IF;
END;
/
 
INSERT_PROCREP_EXCLUSION_OBJ (new 12.2)
Inserts a database object into the exclusion list for procedural replication dbms_goldengate_adm.insert_procrep_exclusion_obj(
package_owner IN VARCHAR2 DEFAULT NULL,
package_name  IN VARCHAR2 DEFAULT NULL,
object_owner  IN VARCHAR2 DEFAULT NULL,
object_name   IN VARCHAR2 DEFAULT NULL);
exec dbms_goldengate_adm.insert_procrep_exclusion_obj('UWCLASS', '???', 'UWCLASS', '???');
 
PURGE_TOMBSTONES (new 12.2)
Purges rows that were deleted before the specified timestamp from the tombstone table dbms_goldengate_adm.purge_tombstones(purge_timestamp IN TIMESTAMP WITH TIME ZONE);
exec dbms_goldengate_adm.purge_tombstones(STANDARD.SYS_AT_TIME_ZONE(SYSTIMESTAMP, 'US/Pacific')-1);
 
REMOVE_AUTO_CDR (new 12.2)
Remove automatic CDR configuration dbms_goldengate_adm.remove_auto_cdr(
schema_name IN VARCHAR2,
table_name  IN VARCHAR2);
exec dbms_goldengate_adm.remove_auto_cdr('UWCLASS', 'SERVERS');
 
REMOVE_AUTO_CDR_COLUMN_GROUP (new 12.2)
Removes a column group configured for automatic conflict detection and resolution dbms_goldengate_adm.remove_auto_cdr_column_group(
schema_name       IN VARCHAR2,
table_name        IN VARCHAR2,
column_group_name IN VARCHAR2);
exec dbms_goldengate_adm.remove_auto_cdr_column_group('UWCLASS', 'SERVERS', 'POSITION_COLGRP'); ???
 
REMOVE_AUTO_CDR_DELTA_RES(new 12.2)
Remove automatic CDR delta resolution for a column dbms_goldengate_adm.remove_auto_cdr_delta_res(
schema_name IN VARCHAR2,
table_name  IN VARCHAR2,
column_name IN VARCHAR2);
exec dbms_goldengate_adm.remove_auto_cdr_delta_res('UWCLASS', 'SERVERS', 'STATUS');

Related Topics
DBMS_GOLDENGATE_AUTH
DBMS_INTERNAL_CLKM
DBMS_XSTREAM_ADM
DBMS_XSTREAM_GG
Dynamic Performance Views
Packages
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved