Skip to content

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

TABLE: SYS.STREAMS$_LOCAL_FINDINGS_IN

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

Temporary Table Details

SYS.STREAMS$_LOCAL_FINDINGS_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
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)
TYPE NUMBER

MORE_INFO_ID NUMBER

INFO_ARG1 VARCHAR2 (4000)
INFO_ARG2 VARCHAR2 (4000)
INFO_ARG3 VARCHAR2 (4000)
INFO_ARG4 VARCHAR2 (4000)
INFO_ARG5 VARCHAR2 (4000)
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
,      TYPE
,      MORE_INFO_ID
,      INFO_ARG1
,      INFO_ARG2
,      INFO_ARG3
,      INFO_ARG4
,      INFO_ARG5
,      ADVISOR_TYPE
,      RUN_TIME
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
FROM SYS.STREAMS$_LOCAL_FINDINGS_IN;

Dependencies

[top of page]

SYS.STREAMS$_LOCAL_FINDINGS_IN does not reference any database object

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