VALIDATE_DIMENSION Procedure

This procedure verifies that the hierarchical and attribute relationships, and join relationships, specified in an existing dimension object are correct. This provides a fast way to ensure that referential integrity is maintained.

The validation results are stored in system tables, which can be accessed through the view SYSTEM.MVIEW_EXCEPTIONS.

Periodically, the unused results can be purged from the system by calling the DBMS_OLAP.PURGE_RESULTS procedure.

See Also: "DBMS_OLAP Interface Views"

Syntax

DBMS_OLAP.VALIDATE_DIMENSION (
   dimension_name    IN VARCHAR2, 
   dimension_owner   IN VARCHAR2, 
   incremental       IN BOOLEAN, 
   check_nulls       IN BOOLEAN,
   run_id            IN NUMBER); 

Parameters

Table 34-17 VALIDATE_DIMENSION Procedure Parameters

Parameter	Description
dimension_name	Name of the dimension to analyze.
dimension_owner	Name of the dimension owner.
incremental	If TRUE, then tests are performed only for the rows specified in the sumdelta$ table for tables of this dimension; otherwise, check all rows.
check_nulls	If TRUE, then all level columns are verified to be non-NULL; otherwise, this check is omitted. Specify FALSE when non-nullness is guaranteed by other means, such as NOT NULL constraints.
run_id	An ID generated by the DBMS_OLAP.CREATE_ID procedure to identify a run