Oracle Tips by Burleson
Oracle 10g Describe 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
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.
DBMS_DIMENSION.DESCRIBE_DIMENSION(’SALES.MYDIM’);y year, so we know exactly how to quickly
assist you with any Oracle question.