About CTX_ADM Package Procedures

The CTX_ADM PL/SQL package provides administrative procedures for managing index preferences.

The CTX_ADM package contains the following stored procedures.

Name Description
MARK_FAILED Changes an index’s status from LOADING to FAILED.
RECOVER Cleans up database objects for deleted Text tables.
RESET_AUTO_OPTIMIZE_STATUS Resets the CTX_AUTO_OPTIMIZE_STATUS view.
SET_PARAMETER Sets system-level defaults for index creation.

Note:

Only the CTXSYS user can use the procedures in the CTX_ADM package.

The APIs in the CTX_ADM package do not support identifiers that are prefixed with the schema or the owner name.