DBMS_PCLXUTIL , 2 of 2

Summary of Subprograms

DBMS_PCLXUTIL contains just one procedure: BUILD_PART_INDEX.

BUILD_PART_INDEX Procedure

Syntax

DBMS_PCLXUTIL.build_part_index ( 
   jobs_per_batch  IN NUMBER   DEFAULT 1, 
   procs_per_job   IN NUMBER   DEFAULT 1, 
   tab_name        IN VARCHAR2 DEFAULT NULL, 
   idx_name        IN VARCHAR2 DEFAULT NULL, 
   force_opt       IN BOOLEAN  DEFAULT FALSE);

Parameters

Table 30-1 BUILD_PART_INDEX Procedure Parameters

Parameter	Description
jobs_per_batch	Number of local indexes to be built concurrently (1 <= `jobs_per_batch` <= number of partitions).
procs_per_job	Number of parallel query slaves to be utilized per local index build (1 <= `procs_per_job` <= `max_slaves`).
tab_name	Name of the partitioned table (an exception is raised if the table does not exist or not partitioned).
idx_name	Name given to the local index (an exception is raised if a local index is not created on the table `tab_name`).
force_opt	If `TRUE`, then force rebuild of all partitioned indices; otherwise, rebuild only the partitions marked '`UNUSABLE`'.

Example

Suppose a table PROJECT is created with two partitions PROJ001 and PROJ002, along with a local index IDX.

A call to the procedure BUILD_PART_INDEX(2,4,'PROJECT','IDX',TRUE) produces the following output:

SQLPLUS> EXECUTE dbms_pclxutil.build_part_index(2,4,'PROJECT','IDX',TRUE); 
Statement processed. 
INFO: Job #21 created for partition PROJ002 with 4 slaves 
INFO: Job #22 created for partition PROJ001 with 4 slaves