[Home] [Help] [Dependency Information]
Object Name: | CDC_CHANGE_SETS$ |
---|---|
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_SETS$ | NORMAL | UNIQUE | SYSTEM | SET_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_NAME | VARCHAR2 | (128) | Yes | |
CHANGE_SOURCE_NAME | VARCHAR2 | (128) | Yes | |
BEGIN_DATE | DATE | |||
END_DATE | DATE | |||
BEGIN_SCN | NUMBER | |||
END_SCN | NUMBER | |||
FRESHNESS_DATE | DATE | |||
FRESHNESS_SCN | NUMBER | |||
ADVANCE_ENABLED | CHAR | (1) | ||
IGNORE_DDL | CHAR | (1) | ||
CREATED | DATE | Yes | ||
ROLLBACK_SEGMENT_NAME | VARCHAR2 | (128) | ||
ADVANCING | CHAR | (1) | Yes | |
PURGING | CHAR | (1) | Yes | |
LOWEST_SCN | NUMBER | |||
TABLESPACE | VARCHAR2 | (30) | ||
LM_SESSION_ID | NUMBER | |||
PARTIAL_TX_DETECTED | CHAR | (1) | ||
LAST_ADVANCE | DATE | |||
LAST_PURGE | DATE | |||
STOP_ON_DDL | CHAR | (1) | Yes | |
CAPTURE_ENABLED | CHAR | (1) | Yes | |
CAPTURE_ERROR | CHAR | (1) | Yes | |
CAPTURE_NAME | VARCHAR2 | (128) | ||
QUEUE_NAME | VARCHAR2 | (128) | ||
QUEUE_TABLE_NAME | VARCHAR2 | (128) | ||
APPLY_NAME | VARCHAR2 | (128) | ||
SUPPLEMENTAL_PROCS | NUMBER | |||
SET_DESCRIPTION | VARCHAR2 | (255) | ||
PUBLISHER | VARCHAR2 | (128) | ||
SET_SEQUENCE | VARCHAR2 | (128) | ||
LOWEST_TIMESTAMP | DATE | |||
TIME_SCN_NAME | VARCHAR2 | (128) |
Cut, paste (and edit) the following text to query this object:
SELECT SET_NAME
, CHANGE_SOURCE_NAME
, BEGIN_DATE
, END_DATE
, BEGIN_SCN
, END_SCN
, FRESHNESS_DATE
, FRESHNESS_SCN
, ADVANCE_ENABLED
, IGNORE_DDL
, CREATED
, ROLLBACK_SEGMENT_NAME
, ADVANCING
, PURGING
, LOWEST_SCN
, TABLESPACE
, LM_SESSION_ID
, PARTIAL_TX_DETECTED
, LAST_ADVANCE
, LAST_PURGE
, STOP_ON_DDL
, CAPTURE_ENABLED
, CAPTURE_ERROR
, CAPTURE_NAME
, QUEUE_NAME
, QUEUE_TABLE_NAME
, APPLY_NAME
, SUPPLEMENTAL_PROCS
, SET_DESCRIPTION
, PUBLISHER
, SET_SEQUENCE
, LOWEST_TIMESTAMP
, TIME_SCN_NAME
FROM SYS.CDC_CHANGE_SETS$;
SYS.CDC_CHANGE_SETS$ does not reference any database object
SYS.CDC_CHANGE_SETS$ is referenced by following:
|
|
|