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

TABLE: PA.PA_RBS_NODES_TEMP

Object Details
Object Name: PA_RBS_NODES_TEMP
Object Type: TABLE
Owner: PA
Subobject Name:
Status: VALID

Temporary Table Details

PA.PA_RBS_NODES_TEMP 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
Indexes
Index Type Uniqueness Tablespace Column
PA_RBS_NODES_TMP_N1 NORMAL NONUNIQUE Tablespace ColumnRBS_LEVEL
ColumnRBS_ELEMENT_ID
ColumnRBS_REF_ELEMENT_ID
PA_RBS_NODES_TMP_N2 NORMAL NONUNIQUE Tablespace ColumnPARENT_REF_ELEMENT_ID
PA_RBS_NODES_TMP_N3 NORMAL NONUNIQUE Tablespace ColumnRBS_REF_ELEMENT_ID
Columns
Name Datatype Length Mandatory Comments
RBS_VERSION_ID NUMBER (15) Yes
RBS_ELEMENT_ID NUMBER (15)
PARENT_ELEMENT_ID NUMBER (15)
RESOURCE_TYPE_ID NUMBER (15) Yes
RESOURCE_SOURCE_ID NUMBER (15)
RESOURCE_SOURCE_CODE VARCHAR2 (240)
ORDER_NUMBER NUMBER (15)
PROCESS_TYPE VARCHAR2 (1) Yes
RBS_LEVEL NUMBER (15) Yes
RECORD_VERSION_NUMBER NUMBER (15)
PARENT_REF_ELEMENT_ID NUMBER (15)
RBS_REF_ELEMENT_ID NUMBER (15)
RECORD_INDEX NUMBER (15)
Query Text

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


SELECT RBS_VERSION_ID
,      RBS_ELEMENT_ID
,      PARENT_ELEMENT_ID
,      RESOURCE_TYPE_ID
,      RESOURCE_SOURCE_ID
,      RESOURCE_SOURCE_CODE
,      ORDER_NUMBER
,      PROCESS_TYPE
,      RBS_LEVEL
,      RECORD_VERSION_NUMBER
,      PARENT_REF_ELEMENT_ID
,      RBS_REF_ELEMENT_ID
,      RECORD_INDEX
FROM PA.PA_RBS_NODES_TEMP;

Dependencies

[top of page]

PA.PA_RBS_NODES_TEMP does not reference any database object

PA.PA_RBS_NODES_TEMP is referenced by following:

SchemaAPPS
SynonymPA_RBS_NODES_TEMP