DATABASE UPGRADE TO 19C REPORTS ERROR "ORA-01403: NOT DATA FOUND"
(Doc ID 2579106.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.1.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
When upgrading database to 19c fails, it reports following error in catupgrd0.log (ORA-01403: no data found)
==Error from catupgrd0.log===
=================================================================
20:34:11 SQL> Rem BEGIN bug 28757685: repair tabpart$
20:34:11 SQL> Rem
=========================================================================
20:34:11 SQL> /* bug 28757685: tabpart$.hiboundval and tabpart$.hiboundlen
are incorrect
20:34:11 SQL> * when tables are autolist partitioned and partitioning
columns are CHAR.
20:34:11 SQL> */
20:34:11 SQL> DECLARE
20:34:11 2 bhiboundval RAW(32767);
20:34:11 3 newhiboundval VARCHAR2(32767);
20:34:11 4 pos BINARY_INTEGER;
20:34:11 5 len BINARY_INTEGER;
20:34:11 6 multicol BOOLEAN;
20:34:11 7 numvals BINARY_INTEGER;
20:34:11 8 posnum BINARY_INTEGER;
20:34:11 9 typenum BINARY_INTEGER;
20:34:11 10 charsetform BINARY_INTEGER;
20:34:11 11 BEGIN
20:34:11 12 FOR alp IN (SELECT tp.obj#, tp.bo#,
..
..
20:34:11 129 WHEN OTHERS THEN
20:34:11 130 DBMS_SYSTEM.ksdwrt(DBMS_SYSTEM.trace_file,
20:34:11 131 'error when repairing tabpart$');
20:34:11 132 RAISE;
20:34:11 133 END;
20:34:11 134 /
DECLARE
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 132
ORA-06512: at line 75
ORA-06512: at line 75
=============
Changes
Database Upgrade to 19c
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 |