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

TABLE: ZPB.ZPB_TABLES

Object Details
Object Name: ZPB_TABLES
Object Type: TABLE
Owner: ZPB
Subobject Name:
Status: VALID


This table contains an entries for olap dimension-tables and olap fact-tables. zpb_dimensions, zpb_hierarchies, and zpb_cubes contain foreign key fields into this table


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ZPB_TABLES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTABLE_ID
ColumnBUS_AREA_ID
ZPB_TABLES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUS_AREA_ID
ColumnTABLE_ID
Columns
Name Datatype Length Mandatory Comments
AW_NAME VARCHAR2 (30)
Name of the workspace that this table belongs to. Superseded by bus_area_id field.
BUS_AREA_ID NUMBER
Yes Business Area to which this table belongs to
TABLE_ID NUMBER
Yes Primary key
TABLE_NAME VARCHAR2 (60)
Name of the olap dimension or fact table
TABLE_TYPE VARCHAR2 (30)
Types include : DIMENSION, HIERARCHY, MEASCUBET (fact table)
CREATED_BY NUMBER (15) Yes Bookkeeping Column
CREATION_DATE DATE
Yes Bookkeeping Column
LAST_UPDATED_BY NUMBER (15) Yes Bookkeeping Column
LAST_UPDATE_DATE DATE
Yes Bookkeeping Column
LAST_UPDATE_LOGIN NUMBER (15) Yes Bookkeeping Column
Query Text

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


SELECT AW_NAME
,      BUS_AREA_ID
,      TABLE_ID
,      TABLE_NAME
,      TABLE_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM ZPB.ZPB_TABLES;

Dependencies

[top of page]

ZPB.ZPB_TABLES does not reference any database object

ZPB.ZPB_TABLES is referenced by following:

SchemaAPPS
SynonymZPB_TABLES