ALL_CUBE_SUB_PARTITION_LEVELS

Previous Next JavaScript must be enabled to correctly display this content

2.151 ALL_CUBE_SUB_PARTITION_LEVELS

ALL_CUBE_SUB_PARTITION_LEVELS describes the OLAP secondary partition levels in the database that are accessible by the user.

Related Views

DBA_CUBE_SUB_PARTITION_LEVELS describes the OLAP secondary partition levels in the database.
USER_CUBE_SUB_PARTITION_LEVELS describes the OLAP secondary partition levels in the database that are owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`		Owner of the OLAP secondary partition level
`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 hierarchy level 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

See Also: