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 will be available on generic Linux platforms in January and soon on AIX and Windows

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.