Oracle DBMS_SUMVDM
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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 12cR1
What's New In 12cR2

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