#GoldenGate Procedural Replication Support

With the release of Oracle GoldenGate 12c (12.3.0.1.x), came the support for Procedural Replication. This option is an enhancement to the integrated replicat which allows you to replicat Oracle-supplied PL/SQL procedures that cannot be replicated as DML or DDL.

Note: In order to replicate these packages and procedures, you need to be on Oracle Database Release 2 (12.2) an later and using the integrated extract and replicat.

To find out what packages and procedures are support, Oracle has provided new data dictionary views that can be used to see what packages and procedures can be used with Oracle GoldenGate. These views are DBA_GG_SUPPORTED_PACKAGES and DBA_GG_SUPPORTED_PROCEDURES. These views can be found in Oracle Database Release 2 (12.2).

As of Oracle GoldenGate 12.3, there are 309 procedures and 36 packages that are support. This number will increase over time.

The packages that are currently supported are:

DBMS_AQ
DBMS_AQADM
DBMS_AQELM
DBMS_AQJMS
DBMS_DBFS_CONTENT_ADMIN
DBMS_DBFS_SFS
DBMS_DBFS_SFS_ADMIN
DBMS_DDL
DBMS_FGA
DBMS_GOLDENGATE_ADM
DBMS_GOLDENGATE_IMP
DBMS_REDACT
DBMS_REDEFINITION
DBMS_RESCONFIG
DBMS_RLS
DBMS_RULE_ADM
DBMS_SQL_TRANSLATOR
DBMS_XDB
DBMS_XDBRESOURCE
DBMS_XDBZ
DBMS_XDB_ADMIN
DBMS_XDB_CONFIG
DBMS_XDB_REPOS
DBMS_XDB_VERSION
DBMS_XMLINDEX
DBMS_XMLSCHEMA
DBMS_XMLSCHEMA_LSB
SDO_META
SDO_META_USER
XS_ACL
XS_ADMIN_UTIL
XS_DATA_SECURITY
XS_DATA_SECURITY_UTIL
XS_NAMESPACE
XS_PRINCIPAL
XS_SECURITY_CLASS

Packages with associated procedures that are currentlly supported are:

DBMS_AQ AQ$_BACKGROUND_OPER
DBMS_AQ AQ$_BACKGROUND_OPER_PAS
DBMS_AQ AQ$_DELETE_DIOT_TAB
DBMS_AQ AQ$_DELETE_HIST_TAB
DBMS_AQ AQ$_DELETE_TIOT_TAB
DBMS_AQ AQ$_DEQUEUE
DBMS_AQ AQ$_ENQUEUE
DBMS_AQ AQ$_INSERT_DIOT_TAB
DBMS_AQ AQ$_INSERT_HIST_TAB
DBMS_AQ AQ$_INSERT_TIOT_TAB
DBMS_AQ AQ$_UPDATE_HIST_TAB
DBMS_AQ AQ$_UPDATE_HIST_TAB_EX
DBMS_AQ BIND_AGENT
DBMS_AQ DEQUEUE
DBMS_AQ DEQUEUE_INTERNAL
DBMS_AQ DEQUEUE_INTERNAL_PAS
DBMS_AQ ENQUEUE
DBMS_AQ ENQUEUE_INT_SHARD
DBMS_AQ ENQUEUE_INT_SHARD_JMS
DBMS_AQ ENQUEUE_INT_UNSHARDED
DBMS_AQ ENQUEUE_INT_UNSHARDED_PAS
DBMS_AQ LISTEN
DBMS_AQ POST
DBMS_AQ REGISTER
DBMS_AQ REGISTRATION_REPLICATION
DBMS_AQ UNBIND_AGENT
DBMS_AQ UNREGISTER
DBMS_AQADM ADD_ALIAS_TO_LDAP
DBMS_AQADM ADD_CONNECTION_TO_LDAP
DBMS_AQADM ADD_SUBSCRIBER
DBMS_AQADM ALTER_AQ_AGENT
DBMS_AQADM ALTER_PROPAGATION_SCHEDULE
DBMS_AQADM ALTER_QUEUE
DBMS_AQADM ALTER_QUEUE_TABLE
DBMS_AQADM ALTER_SHARDED_QUEUE
DBMS_AQADM ALTER_SUBSCRIBER
DBMS_AQADM CREATE_AQ_AGENT
DBMS_AQADM CREATE_EXCEPTION_QUEUE
DBMS_AQADM CREATE_NP_QUEUE
DBMS_AQADM CREATE_QUEUE
DBMS_AQADM CREATE_QUEUE_TABLE
DBMS_AQADM CREATE_SHARDED_QUEUE
DBMS_AQADM DEL_ALIAS_FROM_LDAP
DBMS_AQADM DEL_CONNECTION_FROM_LDAP
DBMS_AQADM DISABLE_DB_ACCESS
DBMS_AQADM DISABLE_PROPAGATION_SCHEDULE
DBMS_AQADM DROP_AQ_AGENT
DBMS_AQADM DROP_QUEUE
DBMS_AQADM DROP_QUEUE_TABLE
DBMS_AQADM DROP_SHARDED_QUEUE
DBMS_AQADM ENABLE_DB_ACCESS
DBMS_AQADM ENABLE_JMS_TYPES
DBMS_AQADM ENABLE_PROPAGATION_SCHEDULE
DBMS_AQADM GET_PROP_SEQNO
DBMS_AQADM GET_REPLAY_INFO
DBMS_AQADM GET_TYPE_INFO
DBMS_AQADM GET_WATERMARK
DBMS_AQADM GRANT_QUEUE_PRIVILEGE
DBMS_AQADM GRANT_SYSTEM_PRIVILEGE
DBMS_AQADM GRANT_TYPE_ACCESS
DBMS_AQADM MIGRATE_QUEUE_TABLE
DBMS_AQADM NONREPUDIATE_RECEIVER
DBMS_AQADM NONREPUDIATE_SENDER
DBMS_AQADM PURGE_QUEUE_TABLE
DBMS_AQADM RECOVER_PROPAGATION
DBMS_AQADM REMOVE_SUBSCRIBER
DBMS_AQADM RESET_REPLAY_INFO
DBMS_AQADM REVOKE_QUEUE_PRIVILEGE
DBMS_AQADM REVOKE_SYSTEM_PRIVILEGE
DBMS_AQADM SCHEDULE_PROPAGATION
DBMS_AQADM SET_WATERMARK
DBMS_AQADM START_QUEUE
DBMS_AQADM START_TIME_MANAGER
DBMS_AQADM STOP_QUEUE
DBMS_AQADM STOP_TIME_MANAGER
DBMS_AQADM UNSCHEDULE_PROPAGATION
DBMS_AQADM VERIFY_QUEUE_TYPES
DBMS_AQADM VERIFY_QUEUE_TYPES_GET_NRP
DBMS_AQADM VERIFY_QUEUE_TYPES_NO_QUEUE
DBMS_AQELM GET_MAILHOST
DBMS_AQELM GET_MAILPORT
DBMS_AQELM GET_PROXY
DBMS_AQELM GET_SENDFROM
DBMS_AQELM GET_TXTIMEOUT
DBMS_AQELM HTTP_SEND
DBMS_AQELM SEND_EMAIL
DBMS_AQELM SET_MAILHOST
DBMS_AQELM SET_MAILPORT
DBMS_AQELM SET_PROXY
DBMS_AQELM SET_SENDFROM
DBMS_AQJMS AQ$_GET_PROP_STAT
DBMS_AQJMS AQ$_GET_TRANS_TYPE
DBMS_AQJMS AQ$_REGISTER
DBMS_AQJMS AQ$_UNREGISTER
DBMS_AQJMS AQ$_UPDATE_PROP_STAT_QNAME
DBMS_AQJMS CLEAR_DBSESSION_GUID
DBMS_AQJMS CLEAR_GLOBAL_AQCLNTDB_CTX_CLNT
DBMS_AQJMS CLEAR_GLOBAL_AQCLNTDB_CTX_DB
DBMS_AQJMS GET_DB_USERNAME_FOR_AGENT
DBMS_AQJMS SET_DBSESSION_GUID
DBMS_AQJMS SET_GLOBAL_AQCLNTDB_CTX
DBMS_AQJMS SUBSCRIBER_EXISTS
DBMS_DBFS_CONTENT_ADMIN EXIM_MOUNT
DBMS_DBFS_CONTENT_ADMIN EXIM_MOUNTP
DBMS_DBFS_CONTENT_ADMIN EXIM_STORE
DBMS_DBFS_CONTENT_ADMIN MOUNTSTORE_LOG
DBMS_DBFS_CONTENT_ADMIN REGISTERSTORE_LOG
DBMS_DBFS_CONTENT_ADMIN UNMOUNTSTORE_LOG
DBMS_DBFS_CONTENT_ADMIN UNREGISTERSTORE_LOG
DBMS_DBFS_SFS NORMALIZEFS
DBMS_DBFS_SFS REORGANIZEFS
DBMS_DBFS_SFS SHRINKFS
DBMS_DBFS_SFS_ADMIN CREATEFILESYSTEM_LOG
DBMS_DBFS_SFS_ADMIN DELETE_ORPHANS_LOG
DBMS_DBFS_SFS_ADMIN DROPFILESYSTEM_LOG
DBMS_DBFS_SFS_ADMIN EXIM_ATTRV
DBMS_DBFS_SFS_ADMIN EXIM_FS
DBMS_DBFS_SFS_ADMIN EXIM_GRANTS
DBMS_DBFS_SFS_ADMIN EXIM_SEQ
DBMS_DBFS_SFS_ADMIN EXIM_SNAP
DBMS_DBFS_SFS_ADMIN EXIM_TABP
DBMS_DBFS_SFS_ADMIN EXIM_TAB_LOG
DBMS_DBFS_SFS_ADMIN EXIM_VOL
DBMS_DBFS_SFS_ADMIN INITFILESYSTEM_LOG
DBMS_DBFS_SFS_ADMIN PARTITION_SEQUENCE_LOG
DBMS_DBFS_SFS_ADMIN RECACHE_SEQUENCE_LOG
DBMS_DBFS_SFS_ADMIN REGISTERFILESYSTEM_LOG
DBMS_DBFS_SFS_ADMIN SETFSPROPERTIES_LOG
DBMS_DBFS_SFS_ADMIN UNREGISTERFILESYSTEM_LOG
DBMS_DDL SET_TRIGGER_FIRING_PROPERTY
DBMS_FGA ADD_POLICY
DBMS_FGA DISABLE_POLICY
DBMS_FGA DROP_POLICY
DBMS_FGA ENABLE_POLICY
DBMS_GOLDENGATE_IMP ACDR_COLUMN
DBMS_GOLDENGATE_IMP ACDR_COLUMN_GROUP
DBMS_GOLDENGATE_IMP ACDR_END
DBMS_GOLDENGATE_IMP ACDR_START
DBMS_GOLDENGATE_IMP ACDR_TABLE
DBMS_REDACT ADD_POLICY
DBMS_REDACT ALTER_POLICY
DBMS_REDACT APPLY_POLICY_EXPR_TO_COL
DBMS_REDACT CREATE_POLICY_EXPRESSION
DBMS_REDACT DISABLE_POLICY
DBMS_REDACT DROP_POLICY
DBMS_REDACT DROP_POLICY_EXPRESSION
DBMS_REDACT ENABLE_POLICY
DBMS_REDACT FPM_MASK
DBMS_REDACT FPM_UNMASK
DBMS_REDACT UPDATE_FULL_REDACTION_VALUES
DBMS_REDACT UPDATE_POLICY_EXPRESSION
DBMS_REDEFINITION ABORT_REDEF_TABLE
DBMS_REDEFINITION ABORT_ROLLBACK
DBMS_REDEFINITION ABORT_UPDATE
DBMS_REDEFINITION CAN_REDEF_TABLE
DBMS_REDEFINITION COPY_TABLE_DEPENDENTS
DBMS_REDEFINITION EXECUTE_UPDATE
DBMS_REDEFINITION FINISH_REDEF_TABLE
DBMS_REDEFINITION REDEF_TABLE
DBMS_REDEFINITION REGISTER_DEPENDENT_OBJECT
DBMS_REDEFINITION ROLLBACK
DBMS_REDEFINITION SET_PARAM
DBMS_REDEFINITION START_REDEF_TABLE
DBMS_REDEFINITION SYNC_INTERIM_TABLE
DBMS_REDEFINITION UNREGISTER_DEPENDENT_OBJECT
DBMS_RESCONFIG ADDREPOSITORYRESCONFIG
DBMS_RESCONFIG ADDRESCONFIG
DBMS_RESCONFIG APPENDRESCONFIG
DBMS_RESCONFIG DELETEREPOSITORYRESCONFIG
DBMS_RESCONFIG DELETERESCONFIG
DBMS_RULE_ADM GRANT_OBJECT_PRIVILEGE
DBMS_RULE_ADM GRANT_SYSTEM_PRIVILEGE
DBMS_RULE_ADM REVOKE_OBJECT_PRIVILEGE
DBMS_RULE_ADM REVOKE_SYSTEM_PRIVILEGE
DBMS_SQL_TRANSLATOR CLEAR_SQL_TRANSLATION_ERROR
DBMS_SQL_TRANSLATOR CREATE_PROFILE
DBMS_SQL_TRANSLATOR DEREGISTER_ERROR_TRANSLATION
DBMS_SQL_TRANSLATOR DEREGISTER_SQL_TRANSLATION
DBMS_SQL_TRANSLATOR DROP_PROFILE
DBMS_SQL_TRANSLATOR ENABLE_ERROR_TRANSLATION
DBMS_SQL_TRANSLATOR ENABLE_SQL_TRANSLATION
DBMS_SQL_TRANSLATOR REGISTER_ERROR_TRANSLATION
DBMS_SQL_TRANSLATOR REGISTER_SQL_TRANSLATION
DBMS_SQL_TRANSLATOR SET_ATTRIBUTE
DBMS_SQL_TRANSLATOR SET_ERROR_TRANSLATION_COMMENT
DBMS_SQL_TRANSLATOR SET_SQL_TRANSLATION_COMMENT
DBMS_SQL_TRANSLATOR SET_SQL_TRANSLATION_MODULE
DBMS_XDBZ ADD_APPLICATION_PRINCIPAL
DBMS_XDBZ CHANGE_APPLICATION_MEMBERSHIP
DBMS_XDBZ DELETE_APPLICATION_PRINCIPAL
DBMS_XDBZ DISABLE_HIERARCHY
DBMS_XDBZ ENABLE_HIERARCHY
DBMS_XDBZ SET_APPLICATION_PRINCIPAL
DBMS_XDB_ADMIN CREATENONCEKEY
DBMS_XDB_ADMIN INSTALLDEFAULTWALLET
DBMS_XDB_ADMIN MOVEXDB_TABLESPACE
DBMS_XDB_ADMIN REBUILDHIERARCHICALINDEX
DBMS_XDB_CONFIG ADDAUTHENTICATIONMAPPING
DBMS_XDB_CONFIG ADDAUTHENTICATIONMETHOD
DBMS_XDB_CONFIG ADDTRUSTMAPPING
DBMS_XDB_CONFIG ADDTRUSTSCHEME
DBMS_XDB_CONFIG CLEARHTTPDIGESTS
DBMS_XDB_CONFIG DELETEAUTHENTICATIONMAPPING
DBMS_XDB_CONFIG DELETEAUTHENTICATIONMETHOD
DBMS_XDB_CONFIG DELETETRUSTMAPPING
DBMS_XDB_CONFIG DELETETRUSTSCHEME
DBMS_XDB_CONFIG ENABLECUSTOMAUTHENTICATION
DBMS_XDB_CONFIG ENABLECUSTOMTRUST
DBMS_XDB_CONFIG ENABLEDIGESTAUTHENTICATION
DBMS_XDB_CONFIG ISGLOBALPORTENABLED
DBMS_XDB_CONFIG SETDYNAMICGROUPSTORE
DBMS_XDB_CONFIG SETGLOBALPORTENABLED
DBMS_XDB_CONFIG SETHTTPCONFIGREALM
DBMS_XDB_VERSION CHECKIN_INT
DBMS_XDB_VERSION CHECKOUT
DBMS_XDB_VERSION MAKEVERSIONED_INT
DBMS_XDB_VERSION UNCHECKOUT_INT
DBMS_XMLINDEX CREATEDATEINDEX
DBMS_XMLINDEX CREATENUMBERINDEX
DBMS_XMLINDEX DROPPARAMETER
DBMS_XMLINDEX MODIFYPARAMETER
DBMS_XMLINDEX PROCESS_PENDING
DBMS_XMLINDEX REGISTERPARAMETER
DBMS_XMLINDEX SYNCINDEX
DBMS_XMLSCHEMA COMPILESCHEMA
DBMS_XMLSCHEMA COPYEVOLVE
DBMS_XMLSCHEMA DELETESCHEMA
DBMS_XMLSCHEMA GENERATEBEAN
DBMS_XMLSCHEMA INPLACEEVOLVE
DBMS_XMLSCHEMA PURGESCHEMA
DBMS_XMLSCHEMA_LSB COPYEVOLVE
DBMS_XMLSCHEMA_LSB REGISTERSCHEMA_BLOB
DBMS_XMLSCHEMA_LSB REGISTERSCHEMA_OID
DBMS_XMLSCHEMA_LSB REGISTERSCHEMA_STR
DBMS_XMLSCHEMA_LSB REGISTERSCHEMA_XML
SDO_META CHANGE_ALL_SDO_GEOM_METADATA
SDO_META CHANGE_IMP_SDO_GEOM_METADATA
SDO_META DELETEGEORSYSENTRY
SDO_META DELETE_ALL_SDO_GEOM_METADATA
SDO_META DELETE_TOPO_METADATA
SDO_META INSERTGEORSYSENTRY
SDO_META INSERT_ALL_SDO_GEOM_METADATA
SDO_META INSERT_TOPO_METADATA
SDO_META UPDATE_TOPO_METADATA
SDO_META_USER CREATEDMLTRIGGER
SDO_META_USER CREATE_TOPO_BTREE
XS_ACL ADD_ACL_PARAMETER
XS_ACL APPEND_ACES
XS_ACL CREATE_ACL
XS_ACL DELETE_ACL
XS_ACL REMOVE_ACES
XS_ACL REMOVE_ACL_PARAMETERS
XS_ACL SET_DESCRIPTION
XS_ACL SET_PARENT_ACL
XS_ACL SET_SECURITY_CLASS
XS_ADMIN_UTIL DROP_SCHEMA_OBJECTS
XS_ADMIN_UTIL GRANT_SYSTEM_PRIVILEGE
XS_ADMIN_UTIL REVOKE_SYSTEM_PRIVILEGE
XS_DATA_SECURITY ADD_COLUMN_CONSTRAINTS
XS_DATA_SECURITY APPEND_REALM_CONSTRAINTS
XS_DATA_SECURITY APPLY_OBJECT_POLICY
XS_DATA_SECURITY CREATE_ACL_PARAMETER
XS_DATA_SECURITY CREATE_POLICY
XS_DATA_SECURITY DELETE_ACL_PARAMETER
XS_DATA_SECURITY DELETE_POLICY
XS_DATA_SECURITY DISABLE_OBJECT_POLICY
XS_DATA_SECURITY ENABLE_OBJECT_POLICY
XS_DATA_SECURITY REMOVE_COLUMN_CONSTRAINTS
XS_DATA_SECURITY REMOVE_OBJECT_POLICY
XS_DATA_SECURITY REMOVE_REALM_CONSTRAINTS
XS_DATA_SECURITY SET_DESCRIPTION
XS_NAMESPACE ADD_ATTRIBUTES
XS_NAMESPACE CREATE_TEMPLATE
XS_NAMESPACE DELETE_TEMPLATE
XS_NAMESPACE REMOVE_ATTRIBUTES
XS_NAMESPACE SET_DESCRIPTION
XS_NAMESPACE SET_HANDLER
XS_PRINCIPAL ADD_PROXY_TO_DBUSER
XS_PRINCIPAL ADD_PROXY_USER
XS_PRINCIPAL CREATE_DYNAMIC_ROLE
XS_PRINCIPAL CREATE_ROLE
XS_PRINCIPAL CREATE_USER
XS_PRINCIPAL DELETE_PRINCIPAL
XS_PRINCIPAL ENABLE_BY_DEFAULT
XS_PRINCIPAL ENABLE_ROLES_BY_DEFAULT
XS_PRINCIPAL GRANT_ROLES
XS_PRINCIPAL REMOVE_PROXY_FROM_DBUSER
XS_PRINCIPAL REMOVE_PROXY_USERS
XS_PRINCIPAL REVOKE_ROLES
XS_PRINCIPAL SET_ACL
XS_PRINCIPAL SET_DESCRIPTION
XS_PRINCIPAL SET_DYNAMIC_ROLE_DURATION
XS_PRINCIPAL SET_DYNAMIC_ROLE_SCOPE
XS_PRINCIPAL SET_EFFECTIVE_DATES
XS_PRINCIPAL SET_GUID
XS_PRINCIPAL SET_PASSWORD
XS_PRINCIPAL SET_PROFILE
XS_PRINCIPAL SET_USER_SCHEMA
XS_PRINCIPAL SET_USER_STATUS
XS_PRINCIPAL SET_VERIFIER
XS_SECURITY_CLASS ADD_IMPLIED_PRIVILEGES
XS_SECURITY_CLASS ADD_PARENTS
XS_SECURITY_CLASS ADD_PRIVILEGES
XS_SECURITY_CLASS CREATE_SECURITY_CLASS
XS_SECURITY_CLASS DELETE_SECURITY_CLASS
XS_SECURITY_CLASS REMOVE_IMPLIED_PRIVILEGES
XS_SECURITY_CLASS REMOVE_PARENTS
XS_SECURITY_CLASS REMOVE_PRIVILEGES
XS_SECURITY_CLASS SET_DESCRIPTION

 

Enjoy!!!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Pardy DBA

ORA-00001: unique constraint (ORA.BLOG_TAGLINE_PK) violated

Martin Widlake's Yet Another Oracle Blog

Oracle performance, Oracle statistics and VLDBs

HeliFromFinland

Heli's thoughts on Database Designing, Oracle SQL Developer Data Modeler, User Groups etc.

Julian Dontcheff's Database Blog

The good DBA is one who learns from his mistakes, the best DBA is one who learns from other DBA's mistakes

Martins Blog

Trying to explain complex things in simple terms

The Data Warrior

Changing the world, one data model at a time. How can I help you?

Maaz Anjum's Blog

A life yet to be lived...

PeteWhoDidNotTweet.com

Stuff that interests me, if not you!

Uwe Hesse

about Database Technology

%d bloggers like this: