[Home] [Help] [Dependency Information]
Object Name: | STREAMS$_APPLY_MILESTONE |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_STREAMS_APPLY_MILESTONE1 | NORMAL | UNIQUE | SYSTEM |
APPLY#
SOURCE_DB_NAME SOURCE_ROOT_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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;
SYS.STREAMS$_APPLY_MILESTONE does not reference any database object
SYS.STREAMS$_APPLY_MILESTONE is referenced by following:
|
|
|