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

TABLE: PO.PO_SESSION_GT

Object Details
Object Name: PO_SESSION_GT
Object Type: TABLE
Owner: PO
Subobject Name:
Status: VALID

For Internal Use Only

Temporary Table Details

PO.PO_SESSION_GT 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
PO_SESSION_GT_N1 NORMAL NONUNIQUE Tablespace ColumnKEY
PO_SESSION_GT_N2 NORMAL NONUNIQUE Tablespace ColumnINDEX_NUM1
PO_SESSION_GT_N3 NORMAL NONUNIQUE Tablespace ColumnINDEX_NUM2
PO_SESSION_GT_N4 NORMAL NONUNIQUE Tablespace ColumnINDEX_CHAR1
PO_SESSION_GT_N5 NORMAL NONUNIQUE Tablespace ColumnINDEX_CHAR2
Columns
Name Datatype Length Mandatory Comments
KEY NUMBER

NUM1 NUMBER

NUM2 NUMBER

NUM3 NUMBER

NUM4 NUMBER

NUM5 NUMBER

NUM6 NUMBER

NUM7 NUMBER

NUM8 NUMBER

NUM9 NUMBER

NUM10 NUMBER

CHAR1 VARCHAR2 (4000)
CHAR2 VARCHAR2 (4000)
CHAR3 VARCHAR2 (4000)
CHAR4 VARCHAR2 (4000)
CHAR5 VARCHAR2 (4000)
DATE1 DATE

DATE2 DATE

INDEX_NUM1 NUMBER

INDEX_NUM2 NUMBER

INDEX_CHAR1 VARCHAR2 (100)
INDEX_CHAR2 VARCHAR2 (100)
CHAR6 VARCHAR2 (4000)
Query Text

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


SELECT KEY
,      NUM1
,      NUM2
,      NUM3
,      NUM4
,      NUM5
,      NUM6
,      NUM7
,      NUM8
,      NUM9
,      NUM10
,      CHAR1
,      CHAR2
,      CHAR3
,      CHAR4
,      CHAR5
,      DATE1
,      DATE2
,      INDEX_NUM1
,      INDEX_NUM2
,      INDEX_CHAR1
,      INDEX_CHAR2
,      CHAR6
FROM PO.PO_SESSION_GT;

Dependencies

[top of page]

PO.PO_SESSION_GT does not reference any database object

PO.PO_SESSION_GT is referenced by following:

SchemaAPPS
SynonymPO_SESSION_GT