PL/SQL Packages DBMS_PCLXUTIL

Create a local index for a partitioned table using parallel query replica processes, circumvents the limitation that, for local index creation, the degree of parallelism is restricted to the number of partitions as only one replica process per partition is utilized.

Subprocedures:

BUILD_PART_INDEX 

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al
Related Commands:

Related Views:

 DBA_PART_INDEXES      ALL_PART_INDEXES      USER_PART_INDEXES    
 DBA_PART_KEY_COLUMNS  ALL_PART_KEY_COLUMNS  USER_PART_KEY_COLUMNS 

 
Copyright © 1999-2024 SS64.com
Some rights reserved