If the table has a large number of partitions, the CREATE SEARCH INDEX statement could fail with the error ORA-06502.

Workaround:

Start with a fewer number of partitions on the table, create the search index, then specify the ALTER TABLE ADD PARTITION statement to add more partitions.

CTX_DDL APIs support the use of long identifiers for the index name but limit the schema name to 25 characters.

Workaround:

If executing a CTX_DDL API as the owner of the index, the schema name can be omitted from the API call. This is helpful for schema names that exceed 25 characters.

Oracle Text indexes and other features cannot be used with application containers, proxy pluggable database (PDB), hot clone, and near-zero downtime relocation.

Workaround:

None.

Indexes using stoplists with stop patterns consume program global area (PGA) memory and can fail with an ORA-04036 error during index creation.

Workaround:

When this error occurs, increase the value of the PGA_AGGREGATE_LIMIT initialization parameter to succeed with the index creation. The PGA_AGGREGATE_LIMIT initialization parameter can be increased using the ALTER SYSTEM statement.

A CTXCAT index cannot be renamed to a name that is more than 25 characters long using the ALTER INDEX RENAME statement.

A CTXCAT index name can be more than 25 characters long (up to 128 characters) if it is created with the CREATE INDEX statement.

Workaround:

None.

A CTXRULE index cannot be renamed to a name that is more than 25 characters long using the ALTER INDEX RENAME statement.

A CTXRULE index name can be more than 25 characters long (up to 128 characters) if it is created with the CREATE INDEX statement.

Workaround:

None.