[Home] [Help] [Dependency Information]
Object Name: | STREAMS$_PROPAGATION_PROCESS |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
STREAMS$_PROP_P_I1 | NORMAL | UNIQUE | SYSTEM | PROPAGATION_NAME |
STREAMS$_PROP_P_I2 | NORMAL | UNIQUE | SYSTEM |
SOURCE_QUEUE_SCHEMA
SOURCE_QUEUE DESTINATION_QUEUE_SCHEMA DESTINATION_QUEUE DESTINATION_DBLINK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROPAGATION_NAME | VARCHAR2 | (128) | Yes | |
SOURCE_QUEUE_SCHEMA | VARCHAR2 | (128) | ||
SOURCE_QUEUE | VARCHAR2 | (128) | ||
DESTINATION_QUEUE_SCHEMA | VARCHAR2 | (128) | ||
DESTINATION_QUEUE | VARCHAR2 | (128) | ||
DESTINATION_DBLINK | VARCHAR2 | (128) | ||
RULESET_SCHEMA | VARCHAR2 | (128) | ||
RULESET | VARCHAR2 | (128) | ||
SPARE1 | NUMBER | |||
SPARE2 | VARCHAR2 | (128) | ||
NEGATIVE_RULESET_SCHEMA | VARCHAR2 | (128) | ||
NEGATIVE_RULESET | VARCHAR2 | (128) | ||
ORIGINAL_PROPAGATION_NAME | VARCHAR2 | (128) | ||
ORIGINAL_SOURCE_QUEUE_SCHEMA | VARCHAR2 | (128) | ||
ORIGINAL_SOURCE_QUEUE | VARCHAR2 | (128) | ||
ACKED_SCN | NUMBER | |||
AUTO_MERGE_THRESHOLD | NUMBER | |||
CREATION_TIME | DATE | |||
ERROR_DATE | DATE | |||
ERROR_MSG | VARCHAR2 | (4000) | ||
UNSCHEDULE_TIME | DATE | |||
SEQNUM | NUMBER | |||
SPARE3 | NUMBER | |||
SPARE4 | NUMBER | |||
SPARE5 | DATE | |||
SPARE6 | DATE | |||
SPARE7 | VARCHAR2 | (4000) | ||
SPARE8 | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT PROPAGATION_NAME
, SOURCE_QUEUE_SCHEMA
, SOURCE_QUEUE
, DESTINATION_QUEUE_SCHEMA
, DESTINATION_QUEUE
, DESTINATION_DBLINK
, RULESET_SCHEMA
, RULESET
, SPARE1
, SPARE2
, NEGATIVE_RULESET_SCHEMA
, NEGATIVE_RULESET
, ORIGINAL_PROPAGATION_NAME
, ORIGINAL_SOURCE_QUEUE_SCHEMA
, ORIGINAL_SOURCE_QUEUE
, ACKED_SCN
, AUTO_MERGE_THRESHOLD
, CREATION_TIME
, ERROR_DATE
, ERROR_MSG
, UNSCHEDULE_TIME
, SEQNUM
, SPARE3
, SPARE4
, SPARE5
, SPARE6
, SPARE7
, SPARE8
FROM SYS.STREAMS$_PROPAGATION_PROCESS;
SYS.STREAMS$_PROPAGATION_PROCESS does not reference any database object
SYS.STREAMS$_PROPAGATION_PROCESS is referenced by following:
|
|
|