MR_REFRESH Procedure

This procedure refreshes the metadata tables that underlie the MRV_OLAP views, as described in "The OLAP API Metadata Reader Views".

Execute MR_REFRESH as the final statement in any script that creates, drops, or updates OLAP Catalog metadata for the OLAP API.

The MR_REFRESH procedure includes a COMMIT. The updates to the metadata tables are saved permanently in the database.

Syntax

MR_REFRESH;