Create a local index for a partitioned table using parallel query slave processes, circumvents the limitation that, for local index creation, the degree of parallelism is restricted to the number of partitions as only one slave process per partition is utilized.
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
DBA_PART_INDEXES ALL_PART_INDEXES USER_PART_INDEXES DBA_PART_KEY_COLUMNS ALL_PART_KEY_COLUMNS USER_PART_KEY_COLUMNS
© Copyright SS64.com 1999-2013
Some rights reserved