1 Reply Latest reply on Oct 31, 2019 6:16 PM by MartinDecker_ora-solutions

    datapatch fails with Error :ORA-01422: "exact fetch returns more than requested number of rows" & ORA-06512: "DBMS_SQLPATCH" (Doc ID 2294009.1)

    MartinDecker_ora-solutions

      Dear Commnuity,

       

      i am facing this issue in a multitenant database where the ORA-1422 errors appears during datapatch not only in CDB$ROOT, but also in PDB$SEED and customer PDB.

       

      Is the workaround of MOS Note  (Doc ID 2294009.1)  of dropping and recreating registry$sqlpatch also applicable for multienant to perform in all containers?

       

      Regards,
      Martin

       

       

       

       

      Take the backup of registry$sqlpatch

       

      SQL>create table registry$sqlpatch_backup as select * from registry$sqlpatch ;

       

      SQL>drop table registry$sqlpatch;

       

      SQL>@?/rdbms/admin/catsqlreg.sql

       

      Re-run ‘datapatch -verbose’