Oracle | DBMS

Oracle DBMS_SUMVDM Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Verify cube dimensions

AUTHID CURRENT_USER

Dependencies

ALL_DIMENSIONS	ALL_DIM_LEVEL_KEY	DBMS_SUMMARY
ALL_DIM_ATTRIBUTES	DBMS_ASSERT	DBMS_SYS_ERROR
ALL_DIM_CHILD_OF	DBMS_DIMENSION	PLITBLM
ALL_DIM_JOIN_KEY	DBMS_SQL	PRVT_DIMENSION_SYS_UTIL
ALL_DIM_LEVELS

Documented No

First Available 11.1

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtsms.plb
{ORACLE_HOME}/rdbms/admin/prvtsmv.plb

VERIFY_DIMENSION

Verify Dimension dbms_sumvdm_verify_dimension( dimension_name VARCHAR2, dimension_owner VARCHAR2, incrmental BOOLEAN, check_nulls BOOLEAN, stmt_id VARCHAR2);

conn sys@pdbdev as sysdba

      

      set serveroutput on

      

      SELECT object_type

      FROM dba_objects

      WHERE owner = 'SH'

      AND object_name = 'CUSTOMERS_DIM';

      

      OBJECT_TYPE

      --------------------

      DIMENSION

      

      exec dbms_sumvdm.verify_dimension('CUSTOMERS_DIM', 'SH');

      *

      ORA-00942: table or view does not exist

      

      -- given that this is undocumented it may well be me but I can't say I'm impressed. And lest you think I was looking for the table not the dimension name:

      

      exec dbms_sumvdm.verify_dimension('CUSTOMERS', 'SH');

      *

      ORA-30478: Specified dimension does not exist

      

      -- so the exception message appear to be internally inconsistent.