VIEW: OLAPSYS.ALL$OLAP_DESCRIPTOR_TYPES

Source

View Text - Preformatted

SELECT
  cty.name descriptor_type
, ot.name entity_type
FROM
  cwm$classificationtype cty
, cwm$objecttype ot
WHERE cty.name <> 'ORACLE_OLAP_CATALOG'
AND cty.irid = ot.classificationtype_irid
WITH READ ONLY

View Text - HTML Formatted

SELECT CTY.NAME DESCRIPTOR_TYPE
, OT.NAME ENTITY_TYPE FROM CWM$CLASSIFICATIONTYPE CTY
, CWM$OBJECTTYPE OT WHERE CTY.NAME <> 'ORACLE_OLAP_CATALOG' AND CTY.IRID = OT.CLASSIFICATIONTYPE_IRID WITH READ ONLY