[Home] [Help] [Dependency Information]
Object Name: | STREAMS$_APPLY_PROCESS |
---|---|
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_PROCESS1 | NORMAL | UNIQUE | SYSTEM | APPLY# |
I_STREAMS_APPLY_PROCESS2 | NORMAL | UNIQUE | SYSTEM | APPLY_NAME |
I_STREAMS_APPLY_PROCESS3 | NORMAL | NONUNIQUE | SYSTEM | QUEUE_OID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLY# | NUMBER | Yes | ||
APPLY_NAME | VARCHAR2 | (128) | Yes | |
QUEUE_OID | RAW | (16) | Yes | |
QUEUE_OWNER | VARCHAR2 | (128) | Yes | |
QUEUE_NAME | VARCHAR2 | (128) | Yes | |
STATUS | NUMBER | |||
FLAGS | NUMBER | |||
RULESET_OWNER | VARCHAR2 | (128) | ||
RULESET_NAME | VARCHAR2 | (128) | ||
MESSAGE_HANDLER | VARCHAR2 | (98) | ||
DDL_HANDLER | VARCHAR2 | (98) | ||
APPLY_USERID | NUMBER | |||
APPLY_DBLINK | VARCHAR2 | (128) | ||
APPLY_TAG | RAW | (2000) | ||
SPARE1 | NUMBER | |||
SPARE2 | NUMBER | |||
SPARE3 | NUMBER | |||
PRECOMMIT_HANDLER | VARCHAR2 | (98) | ||
NEGATIVE_RULESET_OWNER | VARCHAR2 | (128) | ||
NEGATIVE_RULESET_NAME | VARCHAR2 | (128) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
ERROR_NUMBER | NUMBER | |||
ERROR_MESSAGE | VARCHAR2 | (4000) | ||
STATUS_CHANGE_TIME | DATE | |||
UA_NOTIFICATION_HANDLER | VARCHAR2 | (98) | ||
UA_RULESET_OWNER | VARCHAR2 | (128) | ||
UA_RULESET_NAME | VARCHAR2 | (128) | ||
SPARE4 | NUMBER | |||
SPARE5 | NUMBER | |||
SPARE6 | VARCHAR2 | (4000) | ||
SPARE7 | VARCHAR2 | (4000) | ||
SPARE8 | DATE | |||
SPARE9 | DATE | |||
SOURCE_ROOT_NAME | VARCHAR2 | (128) |
Cut, paste (and edit) the following text to query this object:
SELECT APPLY#
, APPLY_NAME
, QUEUE_OID
, QUEUE_OWNER
, QUEUE_NAME
, STATUS
, FLAGS
, RULESET_OWNER
, RULESET_NAME
, MESSAGE_HANDLER
, DDL_HANDLER
, APPLY_USERID
, APPLY_DBLINK
, APPLY_TAG
, SPARE1
, SPARE2
, SPARE3
, PRECOMMIT_HANDLER
, NEGATIVE_RULESET_OWNER
, NEGATIVE_RULESET_NAME
, START_DATE
, END_DATE
, ERROR_NUMBER
, ERROR_MESSAGE
, STATUS_CHANGE_TIME
, UA_NOTIFICATION_HANDLER
, UA_RULESET_OWNER
, UA_RULESET_NAME
, SPARE4
, SPARE5
, SPARE6
, SPARE7
, SPARE8
, SPARE9
, SOURCE_ROOT_NAME
FROM SYS.STREAMS$_APPLY_PROCESS;
SYS.STREAMS$_APPLY_PROCESS does not reference any database object
SYS.STREAMS$_APPLY_PROCESS is referenced by following:
|
|
|