My Oracle Support Banner

ORA-01426: Numeric Overflow After Downgrade From 11g (Doc ID 1308137.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.2.0.2 - Release: 11.1 to 11.2
Information in this document applies to any platform.

Symptoms

After downgrading from 11g to 10.2.0.4, compiling and dropping materialized views may generate an ORA-1426.  Turning off query rewrite lets some queries against tables complete, but compiling and/or dropping the mviews still fails with ORA-1426.

The compile of the materialized view showed this errorstack:
ksesec0 kprcdt kprccu opifcr qerstRowP qersoFetch

The select count(*) from <table> showed this errorstack:
ksesec0 kprcdt kprccu opifcr qersoFetch opifch2 opiall0 opikpr opiodr

Changes

Database was upgraded from 10.2.0.4 to 11.2.0.1; then downgraded to 10.2.0.4.

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!


In this Document
  Symptoms
  Changes
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.