VIEW: OLAPSYS.DBA$OLAP2_CATALOGS

Source

View Text - Preformatted

select
 c.irid catalog_id,
 c.name catalog_name,
 cp.irid parent_catalog_id,
 c.description description
from
 cwm$classification c,
 cwm$classification cp,
 cwm$classificationtype cty,
 cwm$classificationentry ce
where cty.irid = c.classificationtype_irid and
      cty.name = 'ORACLE_OLAP2_CATALOG' and
      c.irid = ce.element_irid and
      ce.name = 'CATALOG2' and
      ce.classification_irid = cp.irid
UNION ALL select
 c.irid catalog_id,
 c.name catalog_name,
 null parent_catalog_id,
 c.description description
from
 cwm$classification c,
 cwm$classificationtype cty
where cty.irid = c.classificationtype_irid and
      cty.name = 'ORACLE_OLAP2_CATALOG' and
      NOT EXISTS
       (select null from cwm$classificationentry ce
        where ce.name = 'CATALOG2' and
              ce.element_irid = c.irid)
with read only

View Text - HTML Formatted

SELECT C.IRID CATALOG_ID
, C.NAME CATALOG_NAME
, CP.IRID PARENT_CATALOG_ID
, C.DESCRIPTION DESCRIPTION FROM CWM$CLASSIFICATION C
, CWM$CLASSIFICATION CP
, CWM$CLASSIFICATIONTYPE CTY
, CWM$CLASSIFICATIONENTRY CE WHERE CTY.IRID = C.CLASSIFICATIONTYPE_IRID AND CTY.NAME = 'ORACLE_OLAP2_CATALOG' AND C.IRID = CE.ELEMENT_IRID AND CE.NAME = 'CATALOG2' AND CE.CLASSIFICATION_IRID = CP.IRID UNION ALL SELECT C.IRID CATALOG_ID
, C.NAME CATALOG_NAME
, NULL PARENT_CATALOG_ID
, C.DESCRIPTION DESCRIPTION FROM CWM$CLASSIFICATION C
, CWM$CLASSIFICATIONTYPE CTY WHERE CTY.IRID = C.CLASSIFICATIONTYPE_IRID AND CTY.NAME = 'ORACLE_OLAP2_CATALOG' AND NOT EXISTS (SELECT NULL
FROM CWM$CLASSIFICATIONENTRY CE
WHERE CE.NAME = 'CATALOG2' AND CE.ELEMENT_IRID = C.IRID) WITH READ ONLY