Select Statement Fails With An ORA-14092
(Doc ID 1589853.1)
Last updated on OCTOBER 15, 2019
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
The following query fails with ORA-14092: number of expressions is not equal to the number of partitioning columns
A.T1_PK = E.CA_DT_MN_FK
AND B.T2_PK = E.T2_FK
AND C.T3_PK = D.T3_FK
AND D.T4_PK = E.T4_FK
AND A.DAY_DATE = TO_DATE('20130701','YYYYMMDD')
AND B.T2_NM = 'TEST SAMPLE'
AND C.T3_CD = '12356-123'
*Cause: Number of expressions submitted to tbl$or$idx$part$num differs
from the number of partitioning columns of the table or index
mapping into partition(s) of which is to be determined
*Action: Supply a correct number of expressions to be used in
determining mapping into partition(s) of a specified table or index
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document