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
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
|
|
|