CHANGE_PROPAGATION_SETS

CHANGE_PROPAGATION_SETS describes the Distributed HotLog change sets on a staging database that use a change propagation. The user must have SELECT_CATALOG_ROLE privilege to access this view. This view is intended for use by Change Data Capture publishers.

Column Datatype NULL Description
PROPAGATION_SOURCE_NAME VARCHAR2(30) NOT NULL Name of change source
PROPAGATION_NAME VARCHAR2(30) NOT NULL Name of Streams propagation
STAGING_DATABASE VARCHAR2(128) NOT NULL Global name of staging database
CHANGE_SET_PUBLISHER VARCHAR2(30) NOT NULL Change set publisher on staging database
CHANGE_SET_NAME VARCHAR2(30) NOT NULL Name of change set on staging database