CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_DIMENSION

Version 11.1
 
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;
 
Related Topics
Dimensions
/rdbms/admin/utldim.sql
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [78 users online]    © 2010 psoug.org