Skip Headers
Oracle® Database PL/SQL Packages and Types Reference
11g Release 2 (11.2)

Part Number E25788-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub
ARPLS400

59 DBMS_DIMENSION

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 the DBMS_DIMENSION package

This chapter contains the following topics:

ARPLS66228

Using DBMS_DIMENSION

This section contains topics which relate to using the DBMS_DIMENSION package.

ARPLS66229

Security Model

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.

ARPLS66230

Summary of DBMS_DIMENSION Subprograms

ARPLS66231Table 59-1 DBMS_DIMENSION Package Subprograms

Subprogram Description

DESCRIBE_DIMENSION Procedure

Prints out the definition of the input dimension, including dimension owner and name, levels, hierarchies, and attributes

VALIDATE_DIMENSION Procedure

Verifies that the relationships specified in a dimension are correct


ARPLS66232

DESCRIBE_DIMENSION Procedure

This procedure displays the definition of the dimension, including dimension name, levels, hierarchies, and attributes. It displays the output using the DBMS_OUTPUT package.

Syntax

DBMS_DIMENSION.DESCRIBE_DIMENSION (
   dimension  IN VARCHAR2);

Parameters

ARPLS66233Table 59-2 DESCRIBE_DIMENSION Procedure Parameter

Parameter Description

dimension

The owner and name of the dimension in the format of owner.name.


ARPLS66234

VALIDATE_DIMENSION Procedure

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.

Syntax

DBMS_DIMENSION.VALIDATE_DIMENSION (
   dimension               IN VARCHAR2,
   incremental             IN BOOLEAN := TRUE,
   check_nulls             IN BOOLEAN := FALSE,
   statement_id            IN VARCHAR2 := NULL );

Parameters

ARPLS66235Table 59-3 VALIDATE_DIMENSION Procedure Parameters

Parameter Description

dimension

The owner and name of the dimension in the format of owner.name.

incremental

If TRUE, check only the new rows for tables of this dimension. If FALSE, check all the rows.

check_nulls

If TRUE, then all level columns are verified to be non-null.

If FALSE, this check is omitted. Specify FALSE when non-NULLness is guaranteed by other means, such as NOT NULL constraints.

statement_id

A client-supplied unique identifier to associate output rows with specific invocations of the procedure.


Reader Comment

   

Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

This Page

This Document

New and changed documents:
RSS Feed HTML RSS Feed PDF