My Oracle Support Banner

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 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

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)] []

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.