| General Information |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmssum.sql |
| First Available |
Created 10/16/97 |
| Dependencies |
| ALL_DIMENSIONS |
DBMS_OUTPUT |
| ALL_DIM_ATTRIBUTES |
DBMS_SUMADVISOR |
| ALL_DIM_CHILD_OF |
DBMS_SUMVDM |
| ALL_DIM_HIERARCHIES |
DBMS_SYS_ERROR |
| ALL_DIM_JOIN_KEY |
DBMS_UTILITY |
| ALL_DIM_LEVELS |
PRVT_DIMENSION_SYS_UTIL |
| ALL_DIM_LEVEL_KEY |
USER_TABLES |
| DBMS_DIMENSION |
|
|
| Object Privileges |
Execute is granted to PUBLIC |
| |
| DESCRIBE_DIMENSION |
| Prints out the definition of the input dimension, including dimension owner and name, levels, hierarchies,
attributes |
dbms_dimension.describe_dimension(dimension IN VARCHAR2);
|
conn / as sysdba
desc sh.times_dim
set serveroutput on
exec dbms_dimension.describe_dimension('SH.TIMES_DIM');
|
| |
| VALIDATE_DIMENSION |
Verifies that the relationships specified in a DIMENSION are correct.
Offending rowids are stored in advisor repository
|
dbms_dimension.validate_dimension(
dimension IN VARCHAR2,
incremental IN BOOLEAN := TRUE,
check_nulls IN BOOLEAN := FALSE,
statement_id IN VARCHAR2 := NULL);
|
conn / as sysdba
exec dbms_dimension.validate_dimension('SH.TIMES_DIM', TRUE, TRUE, 'validate dimension demo');
@$ORACLE_HOME/rdbms/admin/utldim.sql
desc dimension_exceptions
exec dbms_dimension.validate_dimension('SH.TIMES_DIM', TRUE, TRUE, 'validate dimension demo');
SELECT COUNT(*)
FROM dimension_exceptions;
|
