CTX_DDL Package

The CTX_DDL PL/SQL package provides stored procedures and functions to create and manage the preferences, section groups, and stoplists required for Text indexes.

Name	Description
ADD_ATTR_SECTION	Adds an attribute section to an XML section group.
ADD_AUTO_OPTIMIZE	Adds an index or partition to the list of indexes subject to auto optimization.
ADD_FIELD_SECTION	Creates a field section and assigns it to the specified section group.
ADD_INDEX	Adds an index to a catalog index preference.
ADD_MDATA	Changes the MDATA value of a document.
ADD_MDATA_COLUMN	Maps a FILTER BY column to the specified MDATA section.
ADD_MDATA_SECTION	Adds an MDATA metadata section to a document.
ADD_NDATA_SECTION	Adds an NDATA section to a document.
ADD_SDATA_COLUMN	Maps a FILTER BY column to the specified SDATA section.
ADD_SDATA_SECTION	Adds an SDATA structured data section to a document.
ADD_SEC_GRP_ATTR_VAL	Adds a section group attribute value to the list of values of an already existing section group attribute.
ADD_SPECIAL_SECTION	Adds a special section to a section group.
ADD_STOPCLASS	Adds a stopclass to a stoplist.
ADD_STOP_SECTION	Adds a stop section to an automatic section group.
ADD_STOPTHEME	Adds a stoptheme to a stoplist.
ADD_STOPWORD	Adds a stopword to a stoplist.
ADD_SUB_LEXER	Adds a sub-lexer to a multi-lexer preference.
ADD_ZONE_SECTION	Creates a zone section and adds it to the specified section group.
COPY_POLICY	Creates a copy of a policy.
CREATE_INDEX_SET	Creates an index set for CTXCAT index types.
CREATE_POLICY	Creates a policy to use with ORA:CONTAINS().
CREATE_PREFERENCE	Creates a preference in the Text data dictionary.
CREATE_SECTION_GROUP	Creates a section group in the Text data dictionary.
CREATE_SHADOW_INDEX	Creates a policy for the passed-in index. For nonpartitioned index, also creates an index table.
CREATE_STOPLIST	Creates a stoplist.
DROP_INDEX_SET	Drops an index set.
DROP_POLICY	Drops a policy.
DROP_PREFERENCE	Deletes a preference from the Text data dictionary.
DROP_SECTION_GROUP	Deletes a section group from the Text data dictionary.
DROP_SHADOW_INDEX	Drops a shadow index.
DROP_STOPLIST	Drops a stoplist.
EXCHANGE_SHADOW_INDEX	Swaps the shadow index metadata and data.
LOAD_STOPLIST
OPTIMIZE_INDEX	Optimizes the index.
POPULATE_PENDING	Populates the pending queue with every rowid in the base table or table partition.
PREFERENCE_IMPLICIT_COMMIT	Specifies whether procedures related to CTX_DDL preferences issue an implicit commit.
RECREATE_INDEX_ONLINE	Recreates the passed-in index.
REM_SEC_GRP_ATTR_VAL	Removes a specific section group attribute value from the list of values of an existing section group attribute.
REMOVE_AUTO_OPTIMIZE	Removes an index or partition from the list of indexes subject to auto optimization
REMOVE_INDEX	Removes an index from a CTXCAT index preference.
REMOVE_MDATA	Removes MDATA values from a document.
REMOVE_SECTION	Deletes a section from a section group.
REMOVE_STOPCLASS	Deletes a stopclass from a stoplist.
REMOVE_STOPTHEME	Deletes a stoptheme from a stoplist.
REMOVE_STOPWORD	Deletes a stopword from a stoplist.
REMOVE_SUB_LEXER	Deletes a sub-lexer from a multi-lexer preference.
REPLACE_INDEX_METADATA	Replaces metadata for local domain indexes.
SET_ATTRIBUTE	Sets a preference attribute.
SET_SEC_GRP_ATTR	Adds a section group-specific attribute to a section group identified by name.
SET_SECTION_ATTRIBUTE	Sets a section attribute.
SYNC_INDEX	Synchronizes the index.
UNSET_ATTRIBUTE	Removes a set attribute from a preference.
UPDATE_SUB_LEXER	Updates a sub-lexer.
UNSET_SEC_GRP_ATTR	Removes a section group specific attribute.
UPDATE_POLICY	Updates a policy.
UPDATE_SDATA	Updates an SDATA section.

Note: Except CREATE_PREFERENCE and CREATE_SECTION_GROUP, the APIs in the CTX_DDL package do not support identifiers that are prefixed with the schema or owner name.