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