December 2002
Intermediate to advanced
928 pages
85h 29m
English
PROCEDURE 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);
Builds the local index idx_name on partitioned table tab_name with procs_per_job query processes. If force_opt is TRUE, forces a rebuild of all partitioned indexes; otherwise, rebuilds only partitions marked UNUSABLE. jobs_per_batch is supported only until Oracle8i.