These are known bugs for Oracle Text in Oracle Database 12c Release 2 (12.2).
If the table has a large number of partitions, the
CREATE SEARCH INDEX statement could fail with the error
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.
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.
Indexes using stoplists with stop patterns consume program global area (PGA) memory and can fail with an
ORA-04036 error during index creation.
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.
CTXCAT index cannot be renamed to a name that is more than 25 characters long using the
ALTER INDEX RENAME statement.
CTXCAT index name can be more than 25 characters long (up to 128 characters) if it is created with the
CREATE INDEX statement.