CTXSYS.CTX_DDL.OPTIMIZE_INDEX fails with ORA-07445 [qerixtFetch()+966] on text index created with COMPRESS Option

(Doc ID 2367912.1)

Last updated on MARCH 01, 2018

Applies to:

Oracle Text - Version and later
Information in this document applies to any platform.


An attempt to optimize an Oracle Text index fails with an ORA-7445 error

exec CTXSYS.CTX_DDL.OPTIMIZE_INDEX(idx_name => '<index name>', part_name => '<partition name>', optlevel => CTX_DDL.OPTLEVEL_REBUILD,parallel_degree => 1);

SELECT COUNT(*) FROM "DR#<index/partition name>$I";


ORA-07445: Exception aufgetreten: CORE Dump [qerixtFetch()+966] [SIGSEGV] [ADDR:0x0] [PC:0xD827A86] [SI_KERNEL(general_protection)] []


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms