[Home] [Help] [Dependency Information]
Object Name: | STREAMS$_CAPTURE_SERVER |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_STREAMS_CAPTURE_SERVER | NORMAL | UNIQUE | SYSTEM |
CAPTURE_NAME
PROPAGATION_NAME APPLY_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUEUE_SCHEMA | VARCHAR2 | (128) | ||
QUEUE_NAME | VARCHAR2 | (128) | ||
DST_QUEUE_SCHEMA | VARCHAR2 | (128) | ||
DST_QUEUE_NAME | VARCHAR2 | (128) | ||
STARTUP_TIME | DATE | |||
DBLINK | VARCHAR2 | (128) | ||
STATUS | VARCHAR2 | (128) | ||
TOTAL_MSGS | NUMBER | |||
TOTAL_BYTES | NUMBER | |||
LAST_LCR_CREATION_TIME | DATE | |||
LAST_LCR_PROPAGATION_TIME | DATE | |||
DST_DATABASE_NAME | VARCHAR2 | (128) | ||
SESSION_ID | NUMBER | |||
SERIAL# | NUMBER | |||
SPID | VARCHAR2 | (128) | ||
PROPAGATION_NAME | VARCHAR2 | (128) | ||
CAPTURE_NAME | VARCHAR2 | (128) | ||
APPLY_NAME | VARCHAR2 | (128) | ||
APPLY_OBJ# | NUMBER | |||
FIRST_APPLIED_SCN | NUMBER | |||
INACTIVE_TIME | DATE | |||
SUB_NUM | NUMBER | |||
SPARE1 | NUMBER | |||
SPARE2 | NUMBER | |||
SPARE3 | VARCHAR2 | (4000) | ||
SPARE4 | VARCHAR2 | (4000) | ||
SPARE5 | DATE | |||
SPARE6 | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT QUEUE_SCHEMA
, QUEUE_NAME
, DST_QUEUE_SCHEMA
, DST_QUEUE_NAME
, STARTUP_TIME
, DBLINK
, STATUS
, TOTAL_MSGS
, TOTAL_BYTES
, LAST_LCR_CREATION_TIME
, LAST_LCR_PROPAGATION_TIME
, DST_DATABASE_NAME
, SESSION_ID
, SERIAL#
, SPID
, PROPAGATION_NAME
, CAPTURE_NAME
, APPLY_NAME
, APPLY_OBJ#
, FIRST_APPLIED_SCN
, INACTIVE_TIME
, SUB_NUM
, SPARE1
, SPARE2
, SPARE3
, SPARE4
, SPARE5
, SPARE6
FROM SYS.STREAMS$_CAPTURE_SERVER;
SYS.STREAMS$_CAPTURE_SERVER does not reference any database object
SYS.STREAMS$_CAPTURE_SERVER is referenced by following:
|
|
|