 |
|
dbms_dimension.describe_dimension
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
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’);y year, so we know exactly how to quickly
assist you with any Oracle question.
|
