DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_SUBSCRIPTIONS

Object Details
Object Name: CDB_SUBSCRIPTIONS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Change Data Capture subscriptions in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
HANDLE NUMBER
Yes Unique identifier of the subscription
SET_NAME VARCHAR2 (128) Yes Change set for the subscription
USERNAME VARCHAR2 (128) Yes User name of the subscriber
CREATED DATE
Yes Creation date of the subscription
STATUS CHAR (1) Yes Status of the subscriptions (N not activated, A activated)
EARLIEST_SCN NUMBER
Yes Subscription window low boundary
LATEST_SCN NUMBER
Yes Subscription window high boundary
DESCRIPTION VARCHAR2 (255)
Description of the subscription
LAST_PURGED DATE

Last time subscriber called purge_window
LAST_EXTENDED DATE

Last time subscriber called extend_window
SUBSCRIPTION_NAME VARCHAR2 (128) Yes Name of the subscription
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT HANDLE
,      SET_NAME
,      USERNAME
,      CREATED
,      STATUS
,      EARLIEST_SCN
,      LATEST_SCN
,      DESCRIPTION
,      LAST_PURGED
,      LAST_EXTENDED
,      SUBSCRIPTION_NAME
,      CON_ID
FROM SYS.CDB_SUBSCRIPTIONS;

Dependencies

[top of page]

SYS.CDB_SUBSCRIPTIONS does not reference any database object

SYS.CDB_SUBSCRIPTIONS is referenced by following:

SchemaPUBLIC
SynonymCDB_SUBSCRIPTIONS