LOAD_WORKLOAD_USER Procedure

A user-defined workload is loaded using the procedure LOAD_WORKLOAD_USER.

Syntax

DBMS_OLAP.LOAD_WORKLOAD_USER (
workload_id  IN NUMBER,
flags        IN NUMBER,
filter_id    IN NUMBER,
owner_name   IN VARCHAR2,
table_name   IN VARCHAR2);

Table 34-11 LOAD_WORKLOAD_USER Procedure Parameters

Parameter	Datatype	Description
workload_id	NUMBER	The required id that was returned by the DBMS_OLAP.CREATE_ID call
flags	NUMBER	DBMS_OLAP.WORKLOAD_OVERWRITE The load routine will explicitly remove any existing queries from the workload that are owned by the specified collection ID DBMS_OLAP.WORKLOAD_APPEND The load routine preserves any existing queries in the workload. Any queries collected by the load operation will be appended to the end of the specified workload DBMS_OLAP.WORKLOAD_NEW The load routine assumes there are no existing queries in the workload. If it finds an existing workload element, the call will fail with an error Note: the flags have the same behavior irrespective of the LOAD_WORKLOAD operation
filter_id	NUMBER	Specify filter for the workload to be loaded
owner_name	VARCHAR2	The schema that contains the user supplied table or view
table_name	VARCHAR2	The table or view name containing valid workload data