My Oracle Support Banner

Database Upgrade to 19c Fails when it executes utlmmigtbls.sql, with Error: "ORA-01422" for KU$% Objects. (Doc ID 2978946.1)

Last updated on NOVEMBER 26, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


Database upgrade to 19c fails with Error:

SQL> /*****************************************************************************/
SQL> /*
SQL>  * Step 1 - Create the new bootstrap objects and recreate related views.
SQL>  */
SQL> /*****************************************************************************/
SQL> @@utlmmigtbls.sql
SQL> -- FAMILY "EDITION OBJ" - Objects annotated with edition information.
SQL> -- These views are based on "_CURRENT_EDITION_OBJ" in cdcore.sql, and
SQL> -- are intended for internal use only. The difference from cdcore is
SQL> -- that the edition name may be taken from a filter, rather than session
SQL> -- context.
SQL> --
SQL> -- ku$_edition_obj_view - used in place of obj$, when edition semantics
SQL> --  are required.
SQL> declare
  2      use_new_cols       boolean;
  3      type_name_len       number;
  4      success_with_error exception;
  5      objcom           varchar2(10000);
  6      soobj_tail       varchar2(10000);
  7      edobj_tail       varchar2(10000);
  8      pragma exception_init(success_with_error, -24344);
  9      procedure cre_view(vname VARCHAR2, tname VARCHAR2, tail VARCHAR2) as
 10        begin
 22  begin
 23      select length into type_name_len from DBA_TYPE_ATTRS where
 24        TYPE_NAME='KU$_SCHEMAOBJ_T' and
 25        ATTR_NAME='TYPE_NAME';
 26      use_new_cols := ku$$column_exists('OBJ$','DFLCOLLID') or ku$$mig_final;
 28      objcom    :=  q'!
155         where o.owner# = u.user# !';
157      cre_view('ku$_schemaobj_view',          'schemaobj_t', objcom || soobj_tail);
158      cre_view('ku$_edition_schemaobj_view','schemaobj_t', objcom || edobj_tail);
159  end;
160  /
ERROR at line 1:Database Upgrade to 19c Fails when it executes utlmmigtbls.sql, with Error: "ORA-01422" for KU$% Objects.
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 23


Disconnected from Oracle Database 19c Enterprise Edition Release - Production


*******************   Migration   ******************
Serial   Phase #:99   [ORCL] Files:1
Unexpected error encountered in catctlMain; Error Stack Below; exiting
Died at line 9261.
 at line 9261.
    main::catctlDie("\x{a}Unexpected error encountered in catconExec; exiting\x{a} No such"...) called at line 5716
    main::catctlExecutePhaseFiles(99, 1, undef, undef, undef) called at line 2088
    main::catctlRunPhase(99, 1, undef, undef, undef) called at line 2252
    main::catctlRunPhases(0, 108, 108, undef, undef, undef) called at line 2871
    main::catctlRunMainPhases() called at line 1500
    main::catctlMain() called at line 1407
    eval {...} called at line 1405








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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.