| General Information |
| Source |
{ORACLE_HOME}/rdbms/admin/prvtsms.plb |
| First Available |
11.1 |
| Dependencies |
| ALL_DIMENSIONS |
DBMS_DIMENSION |
| ALL_DIM_ATTRIBUTES |
DBMS_SQL |
| ALL_DIM_CHILD_OF |
DBMS_SUMMARY |
| ALL_DIM_JOIN_KEY |
DBMS_SYS_ERROR |
| ALL_DIM_LEVELS |
PLITBLM |
| ALL_DIM_LEVEL_KEY |
PRVT_DIMENSION_SYS_UTIL |
| DBMS_ASSERT |
|
|
| Security Model |
Owned by SYS with no privileges granted |
| |
| 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 |
|
