Format

SDO_CSW.SYNC_INDEX(
    owner          IN VARCHAR2, 
    csw_table_name IN VARCHAR2; 

Description

Updates the XQFT (XML Search-XPath Query Full Text) index on the CSW user data table, by synchronizing the index with the data in the table.

Parameters

owner

Name of the database schema for the table and index.

csw_table_name

Name of the table that holds the CSW catalog data.

Usage Notes

This procedure should be run when there have been significant insert, update, or delete operations on the CSW user data table, because the existing XQFT nidex iautomaticallyically updated.

This procedure updates the index whose name is in the form csw_table_name_XQFT_IDX.

Examples

The following example updates the XQFT index on the MDMETT.CSW_TABLE table.

DECLARE
BEGIN
  sdo_csw.sync_index('MDMETT', 'CSW_TABLE');
END;
/