Select Statement Fails With An ORA-14092
Last updated on MARCH 27, 2014
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 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.CAL_DT_DAY_PK = E.CAL_DT_MON_FK
AND B.RTLR_PK = E.RTLR_FK
AND C.PROD_PK = D.PROD_FK
AND D.PROD_UPC_PK = E.PROD_UPC_FK
AND A.DAY_DT = TO_DATE('20130701','YYYYMMDD')
AND B.RTLR_NM = 'SPORTING GOODS'
AND C.PROD_CD = '12345-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
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