Select Statement Fails With An ORA-14092 (Doc ID 1589853.1)

Last updated on MARCH 27, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Goal

The following query fails with ORA-14092: number of expressions is not equal to the number of partitioning columns

select *

FROM
POS_DIM.CAL_DT_DAY A
,POS_DIM.RTLR B
,POS_DIM.PROD C
,POS_DIM.PROD_UPC D
,POS_DIM.SALES_DETL_WK_FACT E

WHERE
 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'
 

 

ORA-14092  "number of expressions is not equal to the number of partitioning columns"

 *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

 

Solution

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