ORA-01426 While Truncating A Table Or Exchanging Partitions (Doc ID 882997.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.
***Checked for relevance on 29-Aug-2016***


Symptoms

ORA-01426 might be encountered while truncating a table or exchanging partitions greater than 4GB in 11.1

SQL> TRUNCATE TABLE my_table ;
Error at line 1
ORA-01426: numeric overflow

Errorstack trace might contain SQL and stack trace as shown below.

----- Error Stack Dump -----
ORA-01426: numeric overflow

----- Current SQL Statement for this session (sql_id=2j22nc38tjtzs) -----
select inserts, deletes from sys.mon_mods_all$ where obj# = :objn

----- Call Stack Trace -----
ksedst1 ksedst dbkedDefDump dbkdaKsdActDriver dbgdaExecuteAction
dbgdaRunAction dbgdRunActions dbgdProcessEventAct ions dbgdChkEventKgErr
ksfpec dbgePostErrorKGE 884 kgesev ksesec0
kprcdt kprccu opifcr qertbFetchByRowID opifch2
opiall0 opikpr opiodr rpidrus skgmstack
rpidru rpiswu2 kprball ksxmGetInsDelFromMo ksxmUpdateMonForTru
kkbtts_trunc_tbl_se kkbtrn opiexe opiosq0 kpooprx
kpoal8 opiodr ttcpip opitsk opiino
opiodr opidrv sou2o main start

Cause

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