DBMS_DIMENSION
enables you to verify dimension relationships and provides an alternative to the Enterprise Manager Dimension Wizard for displaying a dimension definition.
See Also:
Oracle Database Data Warehousing Guide for detailed conceptual and usage information about theDBMS_DIMENSION
packageThis chapter contains the following topics:
Security Model
This section contains topics which relate to using the DBMS_DIMENSION
package.
Security on this package can be controlled by granting EXECUTE
to selected users or roles.
A user can validate or describe all the dimensions in his own schema. To validate or describe a dimension in another schema, you must have either an object privilege on the dimension or one of the following system privileges: CREATE ANY DIMENSION
, ALTER ANY DIMENSION
, and DROP ANY DIMENSION
.
Table 35-1 DBMS_DIMENSION Package Subprograms
Subprogram | Description |
---|---|
Prints out the definition of the input dimension, including dimension owner and name, levels, hierarchies, and attributes |
|
Verifies that the relationships specified in a dimension are correct |
This procedure displays the definition of the dimension, including dimension name, levels, hierarchies, and attributes. It displays the output using the DBMS_OUTPUT
package.
DBMS_DIMENSION.DESCRIBE_DIMENSION ( dimension IN VARCHAR2);
Table 35-2 DESCRIBE_DIMENSION Procedure Parameter
Parameter | Description |
---|---|
|
The owner and name of the dimension in the format of |
This procedure verifies that the relationships specified in a dimension are valid. The rowid for any row that is found to be invalid will be stored in the table DIMENSION_EXCEPTIONS
in the user's schema.
DBMS_DIMENSION.VALIDATE_DIMENSION ( dimension IN VARCHAR2, incremental IN BOOLEAN := TRUE, check_nulls IN BOOLEAN := FALSE, statement_id IN VARCHAR2 := NULL );
Table 35-3 VALIDATE_DIMENSION Procedure Parameters
Parameter | Description |
---|---|
|
The owner and name of the dimension in the format of |
|
If |
|
If If |
|
A client-supplied unique identifier to associate output rows with specific invocations of the procedure. |