23.2 SDO_CSW.CREATE_XQFT_IDX
Format
SDO_CSW.CREATE_XQFT_IDX( owner IN VARCHAR2, csw_table_name IN VARCHAR2;
Description
Creates an XQFT (XML Search-XPath Query Full Text) index on the CSW table, if no such index already exists.
Parameters
Usage Notes
If an XQFT index already exists on csw_table_name
, and if you only need to update the index by synchronizing it with the current CSW data, you should instead use the SDO_CSW.SYNC_INDEX procedure, because that procedure takes less time to execute than SDO_CSW.CREATE_XQFT_IDX.
If an XQFT index already exists on csw_table_name
, this procedure drops the existing one and re-creates the XQFT index. It also internally calls the CTX_DDL.DROP_PREFERENCE and CTX_DDL.DROP_SECTION_GROUP procedures.
This procedure internally calls the CTX_DDL.CREATE_PEREFERENCE procedure to create a BASIC_LEXER lexer named CSWLEX.
The created index will have a name in the form csw_table_name_XQFT_IDX
.
For information about support for Catalog Services for the Web, see Catalog Services for the Web (CSW) Support.
Examples
The following example creates an XQFT index on the SCOTT.MY_CSW_CATALOG_TABLE table.
DECLARE BEGIN sdo_csw.create_xqft_idx('SCOTT', 'MY_CSW_CATALOG_TABLE'); END; /
Parent topic: SDO_CSW Package (Catalog Services for the Web)