DBA Data[Home] [Help]

VIEW: OLAPSYS.ALL$OLAP2UCUBES

Source

View Text - Preformatted

select owner, cube_name, invalid, display_name, short_description, description,
       mv_summarycode
from olapsys.all$olap1_cubes
union all
select owner, cube_name, invalid, display_name, short_description, description,
       mv_summarycode
from olapsys.all$olap2_cubes
with read only
View Text - HTML Formatted

SELECT OWNER
, CUBE_NAME
, INVALID
, DISPLAY_NAME
, SHORT_DESCRIPTION
, DESCRIPTION
, MV_SUMMARYCODE FROM OLAPSYS.ALL$OLAP1_CUBES UNION ALL SELECT OWNER
, CUBE_NAME
, INVALID
, DISPLAY_NAME
, SHORT_DESCRIPTION
, DESCRIPTION
, MV_SUMMARYCODE FROM OLAPSYS.ALL$OLAP2_CUBES WITH READ ONLY