eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: SYS.STREAMS$_PROPAGATION_PROCESS

Object Details

Object Name:	STREAMS$_PROPAGATION_PROCESS
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Indexes

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

Columns

Name	Datatype	Length	Mandatory
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)

Query Text

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;

Dependencies

[top of page]

SYS.STREAMS$_PROPAGATION_PROCESS does not reference any database object

SYS.STREAMS$_PROPAGATION_PROCESS is referenced by following:

SYS: DBA_PROPAGATION; DBMS_AQADM_SYS - show dependent code; DBMS_LOGREP_UTIL - show dependent code; DBMS_PROPAGATION_INTERNAL - show dependent code; DBMS_PRVTAQIP - show dependent code; DBMS_STREAMS_ADM_UTL - show dependent code; DBMS_STREAMS_AUTO_INT - show dependent code; _DBA_STREAMS_COMPONENT; _DBA_STREAMS_COMPONENT_LINK; _DBA_STREAMS_PROCESSES; _DBA_STREAMS_QUEUES