Oracle | DBMS

Oracle DBMS_SUMVDM Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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

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');

      *

      ERROR at line 1:

      ORA-00942: table or view does not exist

      ORA-06512: at "SYS.DBMS_SQL", line 1120

      ORA-06512: at "SYS.DBMS_SUMVDM", line 962

      ORA-06512: at "SYS.DBMS_SUMVDM", line 302

      ORA-06512: at line 1

      

      -- 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:

      

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

      *

      ERROR at line 1:

      ORA-30478: Specified dimension does not exist

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79

      ORA-06512: at "SYS.DBMS_SUMVDM", line 505

      ORA-06512: at line 1

      

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