 |
|
Oracle Tips by Burleson |
Oracle 10g Describe and Validate Dimensions
It used to always be a challenge to describe
DIMENSION, and we used to depend on dictionary tables, such as
dba_dimensions, and dba_dim_attributes. The Oracle Enterprise
Manager (OEM) package was also useful for describing the structure
of DIMENSION.
With the 10g release, we have a new way of
describing DIMENSION, using the package dbms_dimension. We can use
the describe_dimension procedure in the dbms_dimension package for
this purpose. The following statement executes the procedure.
EXECUTE
DBMS_DIMENSION.DESCRIBE_DIMENSION(’SALES.MYDIM’);
We can also validate a dimension by using the
validate_dimension procedure of the dbms_dimension package. This
procedure is similar to the old dbms_olap.validate_dimension
procedure.
Whenever the validate_dimension procedure
encounters any errors, the errors are written to the
dimension_exceptions table. Therefore, before we run the
validate_dimension procedure, we need to create a local table,
dimension_exceptions. The utldim.sql script needed to create this
table is available in the Oracle Home directory ($ORACLE_HOME/rdbms/admin
on Unix).
Get the complete Oracle10g story:
To get the code instantly, click here:
Need an Oracle Mentor?
BEI is now offering personal mentors for Oracle DBAs where you can have an
Oracle expert right at your fingertips, anytime day or night. We work with
hundreds of Oracle databases every year, so we know exactly how to quickly
assist you with any Oracle question.
Why risk an unplanned outage? You can now get telephone access to Don
Burleson or any of his Oracle Certified DBAs with more than 20 years of
full-time IT experience. Click here for details:
http://www.dba-oracle.com/service_oracle_backup.htm
|
