[Home] [Help] [Dependency Information]
Object Name: | STREAMS$_CAPTURE_PROCESS |
---|---|
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_PROCESS1 | NORMAL | UNIQUE | SYSTEM | CAPTURE# |
I_STREAMS_CAPTURE_PROCESS2 | NORMAL | UNIQUE | SYSTEM | CAPTURE_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUEUE_OID | RAW | (16) | Yes | |
QUEUE_OWNER | VARCHAR2 | (128) | Yes | |
QUEUE_NAME | VARCHAR2 | (128) | Yes | |
CAPTURE# | NUMBER | Yes | ||
CAPTURE_NAME | VARCHAR2 | (128) | Yes | |
STATUS | NUMBER | |||
RULESET_OWNER | VARCHAR2 | (128) | ||
RULESET_NAME | VARCHAR2 | (128) | ||
LOGMNR_SID | NUMBER | |||
PREDUMPSCN | NUMBER | |||
DUMPSEQBEG | NUMBER | |||
DUMPSEQEND | NUMBER | |||
POSTDUMPSCN | NUMBER | |||
FLAGS | NUMBER | |||
START_SCN | NUMBER | |||
CAPTURE_USERID | NUMBER | |||
SPARE1 | NUMBER | |||
SPARE2 | NUMBER | |||
SPARE3 | NUMBER | |||
USE_DBLINK | NUMBER | |||
FIRST_SCN | NUMBER | |||
SOURCE_DBNAME | VARCHAR2 | (128) | ||
NEGATIVE_RULESET_OWNER | VARCHAR2 | (128) | ||
NEGATIVE_RULESET_NAME | VARCHAR2 | (128) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
ERROR_NUMBER | NUMBER | |||
ERROR_MESSAGE | VARCHAR2 | (4000) | ||
STATUS_CHANGE_TIME | DATE | |||
VERSION | VARCHAR2 | (64) | ||
SPARE4 | NUMBER | |||
SPARE5 | NUMBER | |||
SPARE6 | NUMBER | |||
SPARE7 | VARCHAR2 | (1000) | ||
START_SCN_TIME | DATE | |||
FIRST_SCN_TIME | DATE | |||
SOURCE_ROOT_NAME | VARCHAR2 | (128) |
Cut, paste (and edit) the following text to query this object:
SELECT QUEUE_OID
, QUEUE_OWNER
, QUEUE_NAME
, CAPTURE#
, CAPTURE_NAME
, STATUS
, RULESET_OWNER
, RULESET_NAME
, LOGMNR_SID
, PREDUMPSCN
, DUMPSEQBEG
, DUMPSEQEND
, POSTDUMPSCN
, FLAGS
, START_SCN
, CAPTURE_USERID
, SPARE1
, SPARE2
, SPARE3
, USE_DBLINK
, FIRST_SCN
, SOURCE_DBNAME
, NEGATIVE_RULESET_OWNER
, NEGATIVE_RULESET_NAME
, START_DATE
, END_DATE
, ERROR_NUMBER
, ERROR_MESSAGE
, STATUS_CHANGE_TIME
, VERSION
, SPARE4
, SPARE5
, SPARE6
, SPARE7
, START_SCN_TIME
, FIRST_SCN_TIME
, SOURCE_ROOT_NAME
FROM SYS.STREAMS$_CAPTURE_PROCESS;
SYS.STREAMS$_CAPTURE_PROCESS does not reference any database object
SYS.STREAMS$_CAPTURE_PROCESS is referenced by following:
|
|
|