ORA-01426 While Truncating A Table Or Exchanging Partitions
(Doc ID 882997.1)
Last updated on FEBRUARY 02, 2022
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.
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
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 |
| Cause |
| Solution |
| References |