POPULATE_PENDING

This procedure populates the pending queue with every ROWID in the base table or table partition. This procedure is only supported for CONTEXT indexes.

This procedure is valuable for large installations that cannot afford to have the indexing process run continuously, and, therefore, need finer control over creating text indexes. The preferred method is to create an empty index, place all the ROWIDs into the pending queue, and build the index through CTX_DDL.SYNC_INDEX.

Syntax

ctx_ddl.populate_pending(
  idx_name  IN VARCHAR2,
  part_name IN VARCHAR2 DEFAULT NULL
);

idx_name

Name of the CONTEXT indextype.

part_name

Name of the index partition, if any. Must be provided for local partitioned indexes and must be NULL for global, nonpartitioned indexes.

Notes

The SYNC_INDEX is blocked for the duration of the processing. The index unit must be totally empty (idx_docid_count = 0, idx_nextid = 1).

The ROWIDs of rows that are waiting for synchronization into the index are inserted into the DR$INDEX_NAME$C table. You should ensure that there is sufficient space in these tables to hold the ROWIDs of the base table.

Related Topics

• Oracle Text Application Developer’s Guide

• SYNC_INDEX