ORA-7445 [qxopqicx] When Select On View Based On Partitioned Table
(Doc ID 268720.1)
Last updated on APRIL 03, 2020
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 9.2]
Information in this document applies to any platform.
Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material.
Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.
- ORA-3113 (ORA-7445 [qxopqicx] ) on querying a partition view with local domain index defined on
1. create table test_t
( partition_key number(10),
data varchar2(100) )
partition by range ( partition_key )
( partition test_p000 values less than ( 0 ) )
2. create index test_ix01 on test_t ( data )
indextype is ctxsys.context local
3. select *
from ( select distinct data from test_t )
where contains ( data, 'scott' ) > 0
- Step 3 will fail with ORA-3113 (ORA-7445 [qxopqicx]).
- The error is specific to the usage of CONTAINS clause in the SELECT.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!