Oracle DBMS_SUMVDM Demos

Oracle DBMS_SUMVDM Version 11.2.0.3

General Information

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

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

set serveroutput on

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 1053
ORA-06512: at "SYS.DBMS_SUMVDM", line 993
ORA-06512: at "SYS.DBMS_SUMVDM", line 306
ORA-06512: at line 1