Oracle Text Reference Release 9.0.1 Part Number A90121-01 |
|
CTX_DDL Package, 27 of 28
Synchronizes the index to process inserts, updates, and deletes to the base table.
ctx_ddl.sync_index(idx_name IN VARCHAR2 DEFAULT NULL memory IN VARCHAR2 DEFAULT NULL, part_name IN VARCHAR2 DEFAULT NULL);
Specify the name of the index.
Specify the runtime memory to use for synchronization. This value overrides the DEFAULT_INDEX_MEMORY system parameter.
The memory parameter specifies the amount of memory Oracle uses for the synchronization operation before flushing the index to disk. Specifying a large amount of memory:
Specifying smaller amounts of memory increases disk I/O and index fragmentation, but might be useful when runtime memory is scarce.
Specify the name of the index partition to synchronize.
The following example synchronizes the index myindex
with 2 megabytes of memory:
beginctx_ddl.sync_index('myindex', '2M');end;
The following example synchronizes the part1
index partition with 2 megabytes of memory:
beginctx_ddl.sync_index('myindex', '2M', 'part1');end;
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|