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

TABLE: SYS.OLAP_SYNTAX$

Object Details
Object Name: OLAP_SYNTAX$
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_SYNTAX$ NORMAL UNIQUE TablespaceSYSTEM ColumnREF_ROLE
ColumnOWNER_ID
ColumnOWNER_TYPE
ColumnORDER_NUM
SYS_IL0000468210C00005$$ LOB UNIQUE TablespaceSYSTEM
Columns
Name Datatype Length Mandatory Comments
REF_ROLE NUMBER
Yes
OWNER_ID NUMBER
Yes
OWNER_TYPE NUMBER
Yes
ORDER_NUM NUMBER
Yes
SYNTAX_CLOB CLOB (4000) Yes
SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 VARCHAR2 (1000)
SPARE4 VARCHAR2 (1000)
Query Text

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


SELECT REF_ROLE
,      OWNER_ID
,      OWNER_TYPE
,      ORDER_NUM
,      SYNTAX_CLOB
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
FROM SYS.OLAP_SYNTAX$;

Dependencies

[top of page]

SYS.OLAP_SYNTAX$ does not reference any database object

SYS.OLAP_SYNTAX$ is referenced by following:

SchemaSYS
ViewALL_CUBES
ViewALL_CUBE_ATTRIBUTES
ViewALL_CUBE_ATTR_MAPPINGS
ViewALL_CUBE_BUILD_PROCESSES
ViewALL_CUBE_CALCULATED_MEMBERS
ViewALL_CUBE_DIMENSIONS
ViewALL_CUBE_DIMNL_MAPPINGS
ViewALL_CUBE_DIM_MAPPINGS
ViewALL_CUBE_HIERARCHIES
ViewALL_CUBE_MAPPINGS
ViewALL_CUBE_MEASURES
ViewALL_CUBE_MEAS_MAPPINGS
ViewALL_CUBE_NAMED_BUILD_SPECS
ViewDBA_CUBES
ViewDBA_CUBE_ATTR_MAPPINGS
ViewDBA_CUBE_BUILD_PROCESSES
ViewDBA_CUBE_CALCULATED_MEMBERS
ViewDBA_CUBE_DIMENSIONS
ViewDBA_CUBE_DIMNL_MAPPINGS
ViewDBA_CUBE_DIM_MAPPINGS
ViewDBA_CUBE_HIERARCHIES
ViewDBA_CUBE_MAPPINGS
ViewDBA_CUBE_MEASURES
ViewDBA_CUBE_MEAS_MAPPINGS
ViewDBA_CUBE_NAMED_BUILD_SPECS
ViewUSER_CUBES
ViewUSER_CUBE_ATTRIBUTES
ViewUSER_CUBE_ATTR_MAPPINGS
ViewUSER_CUBE_BUILD_PROCESSES
ViewUSER_CUBE_CALCULATED_MEMBERS
ViewUSER_CUBE_DIMENSIONS
ViewUSER_CUBE_DIMNL_MAPPINGS
ViewUSER_CUBE_DIM_MAPPINGS
ViewUSER_CUBE_HIERARCHIES
ViewUSER_CUBE_MAPPINGS
ViewUSER_CUBE_MEASURES
ViewUSER_CUBE_MEAS_MAPPINGS
ViewUSER_CUBE_NAMED_BUILD_SPECS