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

TABLE: FEM.FEM_INTG_DIM_MEMBERS_GT

Object Details
Object Name: FEM_INTG_DIM_MEMBERS_GT
Object Type: TABLE
Owner: FEM
Subobject Name:
Status: VALID

Temporary Table Details

FEM.FEM_INTG_DIM_MEMBERS_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
Columns
Name Datatype Length Mandatory Comments
DIMENSION_ID NUMBER (9) Yes Target dimension identifier
SEGMENT1_VALUE VARCHAR2 (25) Yes Value of first segment used for concatenation
SEGMENT2_VALUE VARCHAR2 (25) Yes Value of second segment used for concatenation
SEGMENT3_VALUE VARCHAR2 (25) Yes Value of third segment used for concatenation
SEGMENT4_VALUE VARCHAR2 (25) Yes Value of fourth segment used for concatenation
SEGMENT5_VALUE VARCHAR2 (25) Yes Value of fifth segment used for concatenation
CONCAT_SEGMENT_VALUE VARCHAR2 (150) Yes Concatenated value
Query Text

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


SELECT DIMENSION_ID
,      SEGMENT1_VALUE
,      SEGMENT2_VALUE
,      SEGMENT3_VALUE
,      SEGMENT4_VALUE
,      SEGMENT5_VALUE
,      CONCAT_SEGMENT_VALUE
FROM FEM.FEM_INTG_DIM_MEMBERS_GT;

Dependencies

[top of page]

FEM.FEM_INTG_DIM_MEMBERS_GT does not reference any database object

FEM.FEM_INTG_DIM_MEMBERS_GT is referenced by following:

SchemaAPPS
SynonymFEM_INTG_DIM_MEMBERS_GT