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$_APPLY_MILESTONE

Object Details

Object Name:	STREAMS$_APPLY_MILESTONE
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
I_STREAMS_APPLY_MILESTONE1	NORMAL	UNIQUE	SYSTEM	APPLY# SOURCE_DB_NAME SOURCE_ROOT_NAME

Columns

Name	Datatype	Length	Mandatory
APPLY#	NUMBER		Yes
SOURCE_DB_NAME	VARCHAR2	(128)
OLDEST_SCN	NUMBER		Yes
COMMIT_SCN	NUMBER		Yes
SYNCH_SCN	NUMBER		Yes
EPOCH	NUMBER		Yes
PROCESSED_SCN	NUMBER		Yes
APPLY_TIME	DATE
APPLIED_MESSAGE_CREATE_TIME	DATE
SPARE1	NUMBER
START_SCN	NUMBER
OLDEST_TRANSACTION_ID	VARCHAR2	(128)
SPILL_LWM_SCN	NUMBER
LWM_EXTERNAL_POS	RAW	(64)
SPARE2	NUMBER
SPARE3	VARCHAR2	(4000)
OLDEST_POSITION	RAW	(64)
SPILL_LWM_POSITION	RAW	(64)
PROCESSED_POSITION	RAW	(64)
START_POSITION	RAW	(64)
XOUT_PROCESSED_POSITION	RAW	(64)
XOUT_PROCESSED_CREATE_TIME	DATE
XOUT_PROCESSED_TID	VARCHAR2	(128)
XOUT_PROCESSED_TIME	DATE
APPLIED_HIGH_POSITION	RAW	(64)
OLDEST_CREATE_TIME	DATE
SPILL_LWM_CREATE_TIME	DATE
SPARE4	RAW	(64)
SPARE5	RAW	(64)
SPARE6	DATE
SPARE7	DATE
SPARE8	NUMBER
SPARE9	NUMBER
SPARE10	TIMESTAMP(6)	(11)
SPARE11	TIMESTAMP(6)	(11)
EAGER_ERROR_RETRY	NUMBER
FLAGS	NUMBER
SOURCE_ROOT_NAME	VARCHAR2	(128)
PTO_RECOVERY_SCN	NUMBER
PTO_RECOVERY_INCARNATION	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPLY#
,      SOURCE_DB_NAME
,      OLDEST_SCN
,      COMMIT_SCN
,      SYNCH_SCN
,      EPOCH
,      PROCESSED_SCN
,      APPLY_TIME
,      APPLIED_MESSAGE_CREATE_TIME
,      SPARE1
,      START_SCN
,      OLDEST_TRANSACTION_ID
,      SPILL_LWM_SCN
,      LWM_EXTERNAL_POS
,      SPARE2
,      SPARE3
,      OLDEST_POSITION
,      SPILL_LWM_POSITION
,      PROCESSED_POSITION
,      START_POSITION
,      XOUT_PROCESSED_POSITION
,      XOUT_PROCESSED_CREATE_TIME
,      XOUT_PROCESSED_TID
,      XOUT_PROCESSED_TIME
,      APPLIED_HIGH_POSITION
,      OLDEST_CREATE_TIME
,      SPILL_LWM_CREATE_TIME
,      SPARE4
,      SPARE5
,      SPARE6
,      SPARE7
,      SPARE8
,      SPARE9
,      SPARE10
,      SPARE11
,      EAGER_ERROR_RETRY
,      FLAGS
,      SOURCE_ROOT_NAME
,      PTO_RECOVERY_SCN
,      PTO_RECOVERY_INCARNATION
FROM SYS.STREAMS$_APPLY_MILESTONE;

Dependencies

[top of page]

SYS.STREAMS$_APPLY_MILESTONE does not reference any database object

SYS.STREAMS$_APPLY_MILESTONE is referenced by following:

SYS: DBA_CAPTURE; DBMS_APPLY_ADM_INTERNAL - show dependent code; DBMS_CAPTURE_SWITCH_INTERNAL - show dependent code; DBMS_LOGREP_IMP_INTERNAL - show dependent code; DBMS_STREAMS_ADM_IVK - show dependent code; DBMS_STREAMS_ADM_UTL - show dependent code; DBMS_XSTREAM_ADM_UTL - show dependent code; _DBA_APPLY_MILESTONE; _DBA_STREAMS_COMPONENT_PROP