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

VIEW: SYS.CDB_PUBLISHED_COLUMNS

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

Source columns available for Change Data Capture in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
CHANGE_SET_NAME VARCHAR2 (128) Yes Change set in which source column is published
CHANGE_TABLE_SCHEMA VARCHAR2 (128) Yes Change table schema in which source column is published
CHANGE_TABLE_NAME VARCHAR2 (128) Yes Change table name in which source column is published
PUB_ID NUMBER
Yes Publication ID in which source column is published
SOURCE_SCHEMA_NAME VARCHAR2 (128) Yes Source schema name of published column
SOURCE_TABLE_NAME VARCHAR2 (128) Yes Source table name of published column
COLUMN_NAME VARCHAR2 (30) Yes Column name of published column
DATA_TYPE VARCHAR2 (106)
Column datatype
DATA_LENGTH NUMBER
Yes Column length
DATA_PRECISION NUMBER

Column precision
DATA_SCALE NUMBER

Column scale
NULLABLE VARCHAR2 (1)
Whether column is nullable
CON_ID NUMBER

container id
Query Text

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


SELECT CHANGE_SET_NAME
,      CHANGE_TABLE_SCHEMA
,      CHANGE_TABLE_NAME
,      PUB_ID
,      SOURCE_SCHEMA_NAME
,      SOURCE_TABLE_NAME
,      COLUMN_NAME
,      DATA_TYPE
,      DATA_LENGTH
,      DATA_PRECISION
,      DATA_SCALE
,      NULLABLE
,      CON_ID
FROM SYS.CDB_PUBLISHED_COLUMNS;

Dependencies

[top of page]

SYS.CDB_PUBLISHED_COLUMNS does not reference any database object

SYS.CDB_PUBLISHED_COLUMNS is referenced by following:

SchemaPUBLIC
SynonymCDB_PUBLISHED_COLUMNS