1 package dbms_pclxutil as
2 ------------
3 -- OVERVIEW
4 --
5 -- a package that provides intra-partition parallelism for creating
6 -- partition-wise local index.
7 --
8 -- SECURITY
9 --
10 -- The execution privilege is granted to PUBLIC. The procedure
11 -- build_part_index in this package run under the caller security.
12 --
13
14 ----------------------------
15
16 ----------------------------
17
18 type JobList is table of number;
19
20 procedure build_part_index (
21 jobs_per_batch in number default 1,
22 procs_per_job in number default 1,
23 tab_name in varchar2 default null,
24 idx_name in varchar2 default null,
25 force_opt in boolean default FALSE);
26 --
27 -- jobs_per_batch: #jobs to be created (1 <= job_count <= #partitions)
28 --
29 -- procs_per_job: #slaves per job (1 <= degree <= max_slaves)
30 --
31 -- tab_name: name of the partitioned table (an exception is
32 -- raised if the table does not exist or not
33 -- partitioned)
34 --
35 -- idx_name: name given to the local index (an exception is
36 -- raised if a local index is not created on the
37 -- table tab_name)
38 --
39 -- force_opt: if TRUE force rebuild of all partitioned indices;
40 -- otherwise rebuild only the partitions marked
41 -- 'UNUSABLE'
42 --
43
44 end dbms_pclxutil;