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

VIEW: SYS.CDB_SUBSCRIBED_TABLES

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

Change Data Capture subscribed tables in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
HANDLE NUMBER
Yes Unique identifier of the subscription
SOURCE_SCHEMA_NAME VARCHAR2 (128) Yes Source schema name of the subscribed table
SOURCE_TABLE_NAME VARCHAR2 (128) Yes Source table name of the subscribed table
VIEW_NAME VARCHAR2 (128)
Subscriber view name for the subscribed table
CHANGE_SET_NAME VARCHAR2 (128) Yes Change set name for the subscribed table
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
,      SOURCE_SCHEMA_NAME
,      SOURCE_TABLE_NAME
,      VIEW_NAME
,      CHANGE_SET_NAME
,      SUBSCRIPTION_NAME
,      CON_ID
FROM SYS.CDB_SUBSCRIBED_TABLES;

Dependencies

[top of page]

SYS.CDB_SUBSCRIBED_TABLES does not reference any database object

SYS.CDB_SUBSCRIBED_TABLES is referenced by following:

SchemaPUBLIC
SynonymCDB_SUBSCRIBED_TABLES