select owner, cube_name, invalid, display_name, short_description,
description, mv_summarycode,
irid, model -- added for export
from olapsys.EXPORTolap1_cubes -- changed for export
union all
select owner, cube_name, invalid, display_name, short_description,
description, mv_summarycode,
irid, model -- added for export
from olapsys.EXPORTolap2_cubes -- changed for export
with read only
SELECT OWNER
, CUBE_NAME
, INVALID
, DISPLAY_NAME
, SHORT_DESCRIPTION
,
DESCRIPTION
, MV_SUMMARYCODE
,
IRID
, MODEL -- ADDED FOR EXPORT
FROM OLAPSYS.EXPORTOLAP1_CUBES -- CHANGED FOR EXPORT
UNION ALL
SELECT OWNER
, CUBE_NAME
, INVALID
, DISPLAY_NAME
, SHORT_DESCRIPTION
,
DESCRIPTION
, MV_SUMMARYCODE
,
IRID
, MODEL -- ADDED FOR EXPORT
FROM OLAPSYS.EXPORTOLAP2_CUBES -- CHANGED FOR EXPORT
WITH READ ONLY
|
|
|