Oracle DBMS_SUMVDM
Version 21c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
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.

Related Topics
Built-in Functions
Built-in Packages
DBMS_SUMMARY
Dimensions
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx