POR_SESSION_GT
POR_SESSION_GT is a Global temporary table that stores the session data.
Details
-
Schema: FUSION
-
Object owner: POR
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| KEY | NUMBER | 18 | Yes | KEY | |
| INDEX_NUM1 | NUMBER | INDEX_NUM1 | |||
| INDEX_NUM2 | NUMBER | INDEX_NUM2 | |||
| INDEX_CHAR1 | VARCHAR2 | 15 | INDEX_CHAR1 | ||
| INDEX_CHAR2 | VARCHAR2 | 15 | INDEX_CHAR2 | ||
| NUM1 | NUMBER | NUM1 | |||
| NUM2 | NUMBER | NUM2 | |||
| NUM3 | NUMBER | NUM3 | |||
| NUM4 | NUMBER | NUM4 | |||
| NUM5 | NUMBER | NUM5 | |||
| NUM6 | NUMBER | NUM6 | |||
| NUM7 | NUMBER | NUM7 | |||
| NUM8 | NUMBER | NUM8 | |||
| NUM9 | NUMBER | NUM9 | |||
| NUM10 | NUMBER | NUM10 | |||
| CHAR1 | VARCHAR2 | 4000 | CHAR1 | ||
| CHAR2 | VARCHAR2 | 4000 | CHAR2 | ||
| CHAR3 | VARCHAR2 | 4000 | CHAR3 | ||
| CHAR4 | VARCHAR2 | 4000 | CHAR4 | ||
| CHAR5 | VARCHAR2 | 4000 | CHAR5 | ||
| CHAR6 | VARCHAR2 | 4000 | CHAR6 | ||
| CHAR7 | VARCHAR2 | 4000 | CHAR7 | ||
| CHAR8 | VARCHAR2 | 4000 | CHAR8 | ||
| CHAR9 | VARCHAR2 | 4000 | CHAR9 | ||
| CHAR10 | VARCHAR2 | 4000 | CHAR10 | ||
| CHAR11 | VARCHAR2 | 4000 | CHAR11 | ||
| CHAR12 | VARCHAR2 | 4000 | CHAR12 | ||
| CHAR13 | VARCHAR2 | 4000 | CHAR13 | ||
| CHAR14 | VARCHAR2 | 4000 | CHAR14 | ||
| CHAR15 | VARCHAR2 | 4000 | CHAR15 | ||
| DATE1 | DATE | DATE1 | |||
| DATE2 | DATE | DATE2 | |||
| DATE3 | DATE | DATE3 | |||
| DATE4 | DATE | DATE4 | |||
| DATE5 | DATE | DATE5 |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| POR_SESSION_GT_N1 | Non Unique | KEY |
| POR_SESSION_GT_N2 | Non Unique | INDEX_NUM1 |
| POR_SESSION_GT_N3 | Non Unique | INDEX_NUM2 |
| POR_SESSION_GT_N4 | Non Unique | INDEX_CHAR1 |
| POR_SESSION_GT_N5 | Non Unique | INDEX_CHAR2 |