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

TABLE: SYS.STREAMS$_LOCAL_ACTIONS_IN

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

Temporary Table Details

SYS.STREAMS$_LOCAL_ACTIONS_IN is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000470686C00014$$ LOB UNIQUE TablespaceSYSTEM
SYS_IL0000470686C00015$$ LOB UNIQUE TablespaceSYSTEM
Columns
Name Datatype Length Mandatory Comments
MESSAGE_ID NUMBER

MESSAGE_ARG1 VARCHAR2 (4000)
MESSAGE_ARG2 VARCHAR2 (4000)
MESSAGE_ARG3 VARCHAR2 (4000)
MESSAGE_ARG4 VARCHAR2 (4000)
MESSAGE_ARG5 VARCHAR2 (4000)
COMMAND VARCHAR2 (64)
COMMAND_ID NUMBER

FLAGS NUMBER

ATTR1 VARCHAR2 (4000)
ATTR2 VARCHAR2 (4000)
ATTR3 VARCHAR2 (4000)
ATTR4 VARCHAR2 (4000)
ATTR5 CLOB (4000)
ATTR6 CLOB (4000)
NUM_ATTR1 NUMBER

NUM_ATTR2 NUMBER

NUM_ATTR3 NUMBER

NUM_ATTR4 NUMBER

NUM_ATTR5 NUMBER

ADVISOR_TYPE VARCHAR2 (30)
RUN_TIME DATE

SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 VARCHAR2 (4000)
SPARE4 DATE

Query Text

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


SELECT MESSAGE_ID
,      MESSAGE_ARG1
,      MESSAGE_ARG2
,      MESSAGE_ARG3
,      MESSAGE_ARG4
,      MESSAGE_ARG5
,      COMMAND
,      COMMAND_ID
,      FLAGS
,      ATTR1
,      ATTR2
,      ATTR3
,      ATTR4
,      ATTR5
,      ATTR6
,      NUM_ATTR1
,      NUM_ATTR2
,      NUM_ATTR3
,      NUM_ATTR4
,      NUM_ATTR5
,      ADVISOR_TYPE
,      RUN_TIME
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
FROM SYS.STREAMS$_LOCAL_ACTIONS_IN;

Dependencies

[top of page]

SYS.STREAMS$_LOCAL_ACTIONS_IN does not reference any database object

SYS.STREAMS$_LOCAL_ACTIONS_IN is not referenced by any database object