ORA-1407 During Database Conversion Using DMU (Doc ID 2109328.1)

Last updated on AUGUST 09, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Database Migration Assistant for Unicode - Version 2.1 and later
Information in this document applies to any platform.
***Checked for relevance on 09-Aug-2017***

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

 

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