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


TABLE: IBE.IBE_TEMP_TABLE

Object Details
Object Name: IBE_TEMP_TABLE
Object Type: TABLE
Owner: IBE
Subobject Name:
Status: VALID

Temporary Table Details

IBE.IBE_TEMP_TABLE 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$TRANSACTION. 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
KEY VARCHAR2 (30)
NUM_VAL NUMBER

CHAR_VAL VARCHAR2 (240)
DATE_VAL DATE

Query Text

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


SELECT KEY
,      NUM_VAL
,      CHAR_VAL
,      DATE_VAL
FROM IBE.IBE_TEMP_TABLE;

Dependencies

[top of page]

IBE.IBE_TEMP_TABLE does not reference any database object

IBE.IBE_TEMP_TABLE is referenced by following:

SchemaAPPS
SynonymIBE_TEMP_TABLE