SYNC_INDEX

Synchronizes the index to process inserts, updates, and deletes. This is the same as synchronizing with ALTER INDEX.

Syntax

ctx_ddl.sync_index(idx_name  in  varchar2 default NULL); 

idx_name

Specify the name of the index.

Example

begin
ctx_ddl.sync_index(myindex);
end;

Related Topics

ALTER INDEX in Chapter 2.