My Oracle Support Banner

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 9.2.0.1 to 9.2.0.5 [Release 9.2]
Information in this document applies to any platform.

Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the
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
underlying table.

Example :-
~~~~~~~

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.

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.