The ALTER
INDEX
and CREATE
INDEX
statements support incrementally creating a global CONTEXT
index.
For creating a global index, CREATE
INDEX
supports the NOPOPULATE
keyword of the REBUILD
clause. Using the NOPOPULATE
keyword in the REPLACE
parameter, you can create indexes incrementally. This is valuable for creating text indexes in large installations that cannot afford to have the indexing process running continuously.
For creating a local index partition, ALTER
INDEX
... REBUILD
partition
... parameters
('REPLACE
...') parameter string is modified to support the NOPOPULATE
keyword.
For creating a partition on a local index, CREATE
INDEX
... LOCAL
... (partition
... parameters
('NOPOPULATE
')) is supported. The partition-level POPULATE
or NOPOPULATE
keywords override any POPULATE
or NOPOPULATE
specified at the index level.
Oracle Text Reference to learn more about the syntax for the ALTER
INDEX
and CREATE
INDEX
statements