DBA Data[Home] [Help]

VIEW: OLAPSYS.DBA$OLAP2UCUBES

Source

View Text - Preformatted

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

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