Oracle DBMS_SUMVDM
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,
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@pdborcl 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
Dimensions
Packages

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