Oracle DBMS_SUMVDM
Version 18.3

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

SQL> SELECT object_type
2 FROM dba_objects
3 WHERE owner = 'SH'
4 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
DBMS_SUMREF_UTIL
Dimensions
What's New In 18c
What's New In 19c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx