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


TABLE: SYS.OLAP_TAB_COL$

Object Details
Object Name: OLAP_TAB_COL$
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
I_OLAP_TAB_COL$ NORMAL NONUNIQUE TablespaceSYSTEM ColumnOBJ#
Columns
Name Datatype Length Mandatory Comments
OBJ# NUMBER
Yes
COL# NUMBER
Yes
PCOL# NUMBER

COLTYPE NUMBER
Yes
OID NUMBER
Yes
QDROID NUMBER

QDRVAL VARCHAR2 (100)
HIER# NUMBER

FLAGS NUMBER
Yes
Query Text

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


SELECT OBJ#
,      COL#
,      PCOL#
,      COLTYPE
,      OID
,      QDROID
,      QDRVAL
,      HIER#
,      FLAGS
FROM SYS.OLAP_TAB_COL$;

Dependencies

[top of page]

SYS.OLAP_TAB_COL$ does not reference any database object

SYS.OLAP_TAB_COL$ is referenced by following:

SchemaSYS
ViewKU$_CUBE_FACT_VIEW
ViewKU$_CUBE_TAB_VIEW