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

VIEW: SYS.DBA_CUBE_SUB_PARTITION_LEVELS

Object Details
Object Name: DBA_CUBE_SUB_PARTITION_LEVELS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

OLAP Secondary Partition Levels in the database

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128)
Owner of the OLAP secondary partition levels
CUBE_NAME VARCHAR2 (128)
Name of the OLAP Cube
SUB_PARTITION_LEVEL_NAME VARCHAR2 (200)
Name of the secondary partition level of the OLAP Cube
PRECOMPUTE_PERCENT NUMBER

Precompute percent of the secondary partition level of the OLAP Cube
PARTITION_DIMENSION_NAME VARCHAR2 (128)
Name of the Cube Dimension for which there is a secondary partition level on the OLAP Cube
PARTITION_HIERARCHY_NAME VARCHAR2 (128)
Name of the Hierarchy for which there is a secondary partition level on the OLAP Cube
PARTITION_LEVEL_NAME VARCHAR2 (128)
Name of the HierarchyLevel for which there is a secondary partition level on the OLAP Cube
SUB_PARTITION_LEVEL_ORDER NUMBER

Order number of the secondary partition level on the OLAP cube
Query Text

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


SELECT OWNER
,      CUBE_NAME
,      SUB_PARTITION_LEVEL_NAME
,      PRECOMPUTE_PERCENT
,      PARTITION_DIMENSION_NAME
,      PARTITION_HIERARCHY_NAME
,      PARTITION_LEVEL_NAME
,      SUB_PARTITION_LEVEL_ORDER
FROM SYS.DBA_CUBE_SUB_PARTITION_LEVELS;

Dependencies

[top of page]

SYS.DBA_CUBE_SUB_PARTITION_LEVELS references the following:

SchemaSYS
TableOBJ$
TableOLAP_CUBES$
TableOLAP_DIM_LEVELS$
TableOLAP_HIERARCHIES$
TableOLAP_HIER_LEVELS$
TableOLAP_IMPL_OPTIONS$
TableOLAP_MULTI_OPTIONS$
TableUSER$
SYS.DBA_CUBE_SUB_PARTITION_LEVELS is referenced by following:

SchemaPUBLIC
SynonymDBA_CUBE_SUB_PARTITION_LEVELS