VIEW: OLAPSYS.ALL$OLAP_DESCRIPTORS

Source

View Text - Preformatted

SELECT
  c.irid descriptor_id
, c.name descriptor_value
, cty.name descriptor_type
, c.description description
FROM
  cwm$classification c
, cwm$classificationtype cty
WHERE cty.irid = c.classificationtype_irid
AND cty.name <> 'ORACLE_OLAP_CATALOG'
WITH READ ONLY

View Text - HTML Formatted

SELECT C.IRID DESCRIPTOR_ID
, C.NAME DESCRIPTOR_VALUE
, CTY.NAME DESCRIPTOR_TYPE
, C.DESCRIPTION DESCRIPTION FROM CWM$CLASSIFICATION C
, CWM$CLASSIFICATIONTYPE CTY WHERE CTY.IRID = C.CLASSIFICATIONTYPE_IRID AND CTY.NAME <> 'ORACLE_OLAP_CATALOG' WITH READ ONLY