VALIDATE_WORKLOAD_USER Procedure

This procedure validates the user-supplied workload before performing load operations.

Syntax

DBMS_OLAP.VALIDATE_WORKLOAD_USER (
   owner_name       IN  VARCHAR2, 
   table_name       IN  VARCHAR2, 
   valid            OUT NUMBER, 
   error            OUT VARCHAR2); 

Parameters

Table 34-20 VALIDATE_WORKLOAD_USER Procedure Parameters

Parameter	Description
owner_name	Owner of the user workload table
table_name	User workload table name
valid	Return DBMS_OLAP.VALID or DBMS_OLAP.INVALID Indicate whether a workload is valid.
error	VARCHAR2, return error set

DBMS_OLAP Interface Views

Several views are created when using DBMS_OLAP. All are in the SYSTEM schema. To access these views, you must have a DBA role.

See Also: Oracle9i Data Warehousing Guide for more information regarding how to use DBMS_OLAP