[Home] [Help] [Dependency Information]
Object Name: | APPLY$_ERROR |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
STREAMS$_APPLY_ERROR_UNQ | NORMAL | UNIQUE | SYSAUX | LOCAL_TRANSACTION_ID |
STREAMS$_APPLY_ERROR_IDX_2 | NORMAL | NONUNIQUE | SYSTEM | APPLY# |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOCAL_TRANSACTION_ID | VARCHAR2 | (22) | ||
SOURCE_TRANSACTION_ID | VARCHAR2 | (128) | ||
SOURCE_DATABASE | VARCHAR2 | (128) | ||
QUEUE_OWNER | VARCHAR2 | (128) | Yes | |
QUEUE_NAME | VARCHAR2 | (128) | Yes | |
APPLY# | NUMBER | Yes | ||
MESSAGE_NUMBER | NUMBER | |||
MESSAGE_COUNT | NUMBER | |||
MIN_STEP_NO | NUMBER | |||
RECIPIENT_ID | NUMBER | |||
RECIPIENT_NAME | VARCHAR2 | (128) | ||
SOURCE_COMMIT_SCN | NUMBER | |||
ERROR_NUMBER | NUMBER | |||
ERROR_MESSAGE | VARCHAR2 | (4000) | ||
AQ_TRANSACTION_ID | VARCHAR2 | (30) | ||
SPARE1 | NUMBER | |||
SPARE2 | NUMBER | |||
SPARE3 | NUMBER | |||
ERROR_CREATION_TIME | DATE | |||
EXTERNAL_SOURCE_POS | RAW | (64) | ||
SPARE4 | RAW | (2000) | ||
SPARE5 | VARCHAR2 | (4000) | ||
COMMIT_TIME | NUMBER | |||
XIDUSN | NUMBER | |||
XIDSLT | NUMBER | |||
XIDSQN | NUMBER | |||
RETRY_COUNT | NUMBER | |||
FLAGS | NUMBER | |||
ERROR_POS | RAW | (64) | ||
START_SEQ# | NUMBER | |||
END_SEQ# | NUMBER | |||
START_RBA | NUMBER | |||
END_RBA | NUMBER | |||
ERROR_SEQ# | NUMBER | |||
ERROR_RBA | NUMBER | |||
ERROR_INDEX# | NUMBER | |||
SPARE6 | NUMBER | |||
SPARE7 | NUMBER | |||
SPARE8 | VARCHAR2 | (4000) | ||
SPARE9 | VARCHAR2 | (4000) | ||
SPARE10 | RAW | (1000) | ||
SPARE11 | RAW | (1000) | ||
SPARE12 | TIMESTAMP(6) | (11) |
Cut, paste (and edit) the following text to query this object:
SELECT LOCAL_TRANSACTION_ID
, SOURCE_TRANSACTION_ID
, SOURCE_DATABASE
, QUEUE_OWNER
, QUEUE_NAME
, APPLY#
, MESSAGE_NUMBER
, MESSAGE_COUNT
, MIN_STEP_NO
, RECIPIENT_ID
, RECIPIENT_NAME
, SOURCE_COMMIT_SCN
, ERROR_NUMBER
, ERROR_MESSAGE
, AQ_TRANSACTION_ID
, SPARE1
, SPARE2
, SPARE3
, ERROR_CREATION_TIME
, EXTERNAL_SOURCE_POS
, SPARE4
, SPARE5
, COMMIT_TIME
, XIDUSN
, XIDSLT
, XIDSQN
, RETRY_COUNT
, FLAGS
, ERROR_POS
, START_SEQ#
, END_SEQ#
, START_RBA
, END_RBA
, ERROR_SEQ#
, ERROR_RBA
, ERROR_INDEX#
, SPARE6
, SPARE7
, SPARE8
, SPARE9
, SPARE10
, SPARE11
, SPARE12
FROM SYS.APPLY$_ERROR;
SYS.APPLY$_ERROR does not reference any database object
SYS.APPLY$_ERROR is referenced by following:
|
|
|