ORA-1407 During Database Conversion Using DMU
(Doc ID 2109328.1)
Last updated on FEBRUARY 19, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterDatabase Migration Assistant for Unicode - Version 2.1 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
ORA-1407 reported in DMU with following errors in the log file:
SELECT s.SERIAL# from v$session s where s.sid = (SELECT USERENV('SID') FROM
DUAL)
18.09:06:24:675;V011;F;09999 SQL text is DECLARE
BEGIN
UPDATE system.dum$tables dt SET dt.old_obj# =dt.obj#, dt.obj# = (SELECT
o_new.obj# FROM sys.obj$ o_old, sys.obj$ o_new WHERE o_old.obj# = dt.obj# AND
o_new.name ='DUM$ZSIP_ZDARZENIA$1770113' AND o_old.owner# = o_new.owner# AND
o_old.type# = o_new.type#) WHERE dt.obj# = 1770113;
UPDATE system.dum$columns dc SET dc.old_intcol# = dc.intcol#, dc.intcol# =
(SELECT c_new.intcol# FROM sys.col$ c_old, sys.col$ c_new WHERE c_old.intcol#
= dc.intcol# AND c_old.name = c_new.name AND c_old.obj# = dc.obj# AND
c_new.obj# = (SELECT dt.obj# FROM system.dum$tables dt WHERE dt.old_obj# =
c_old.obj#)), dc.obj#=(SELECT dt.obj# FROM system.dum$tables dt WHERE
dt.old_obj# = dc.obj#)WHERE dc.obj# = 1770113;
END;;
Connection ID is 11. Connection session ID is 1026, serial number is 52691.
Exception error code is 1407.
Exception call stack is
java.sql.SQLException: ORA-1407: cannot update
("SYSTEM"."DUM$COLUMNS"."INTCOL#") to NULL
ORA-6512: at line 4
Changes
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 |