[Home] [Help] [Dependency Information]
Object Name: | CDC_CHANGE_SOURCES$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_CDC_CHANGE_SOURCES$ | NORMAL | UNIQUE | SYSTEM | SOURCE_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SOURCE_NAME | VARCHAR2 | (128) | Yes | |
DBID | NUMBER | |||
LOGFILE_LOCATION | VARCHAR2 | (2000) | ||
LOGFILE_SUFFIX | VARCHAR2 | (128) | ||
SOURCE_DESCRIPTION | VARCHAR2 | (255) | ||
CREATED | DATE | Yes | ||
SOURCE_TYPE | NUMBER | Yes | ||
SOURCE_DATABASE | VARCHAR2 | (128) | ||
SOURCE_DBID | VARCHAR2 | (16) | ||
FIRST_SCN | NUMBER | |||
FIRST_LOGFILE | VARCHAR2 | (2000) | ||
LOGFILE_FORMAT | VARCHAR2 | (2000) | ||
PUBLISHER | VARCHAR2 | (128) | ||
CAPTURE_NAME | VARCHAR2 | (128) | ||
CAPQUEUE_NAME | VARCHAR2 | (128) | ||
CAPQUEUE_TABNAME | VARCHAR2 | (128) | ||
SOURCE_ENABLED | CHAR | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT SOURCE_NAME
, DBID
, LOGFILE_LOCATION
, LOGFILE_SUFFIX
, SOURCE_DESCRIPTION
, CREATED
, SOURCE_TYPE
, SOURCE_DATABASE
, SOURCE_DBID
, FIRST_SCN
, FIRST_LOGFILE
, LOGFILE_FORMAT
, PUBLISHER
, CAPTURE_NAME
, CAPQUEUE_NAME
, CAPQUEUE_TABNAME
, SOURCE_ENABLED
FROM SYS.CDC_CHANGE_SOURCES$;
SYS.CDC_CHANGE_SOURCES$ does not reference any database object
SYS.CDC_CHANGE_SOURCES$ is referenced by following:
|
|
|