| General Information |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmssum.sql |
| First Available |
Created 16-OCT-1997 |
| 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 |
|
| Security Model |
Execute is granted to PUBLIC |
| Subprograms |
|
| |
| DESCRIBE_DIMENSION |
Prints out the definition of the input dimension, including dimension owner and name, levels, hierarchies, attributes.
This script uses the objects built with {$ORACLE_HOME}/rdbms/admin/utldim.sql |
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.
This overload is for compatibility with 8i and 9i databases.
Overload 1 |
dbms_dimension.validate_dimension(
dimension_name IN VARCHAR2,
dimension_owner IN VARCHAR2,
incremental IN BOOLEAN,
check_nulls IN BOOLEAN := FALSE); |
conn / as sysdba
exec dbms_dimension.validate_dimension('TIMES_DIM', 'SH', TRUE, TRUE); |
Verifies that the relationships specified in a DIMENSION are correct. Offending rowids are stored in advisor repository.
This overload is for compatibility with 10g and newer databases.
Overload 2 |
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; |
