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


TABLE: SYS.PSTUBTBL

Object Details
Object Name: PSTUBTBL
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Temporary Table Details

SYS.PSTUBTBL 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
USERNAME VARCHAR2 (128)
DBNAME VARCHAR2 (128)
LUN VARCHAR2 (128)
LUTYPE VARCHAR2 (3)
LINENO NUMBER

LINE VARCHAR2 (1800)
Query Text

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


SELECT USERNAME
,      DBNAME
,      LUN
,      LUTYPE
,      LINENO
,      LINE
FROM SYS.PSTUBTBL;

Dependencies

[top of page]

SYS.PSTUBTBL does not reference any database object

SYS.PSTUBTBL is not referenced by any database object