Viewing OLAP Catalog Metadata , 16 of 25

ALL_OLAP2_CATALOGS

ALL_OLAP2_CATALOGS lists all the measure folders (catalogs) within the Oracle instance.

Column	Data Type	NULL	Description
`CATALOG_ID`	`NUMBER`	`NOT NULL`	ID of the measure folder.
`CATALOG_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the measure folder.
`PARENT_CATALOG_ID`	`NUMBER`		ID of the parent measure folder. This column is null for measure folders at the root of the measure folder tree.
`DESCRIPTION`	`VARCHAR2(2000)`		Description of the measure folder.