Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

datapatch fails with Error :ORA-01422: "exact fetch returns more than requested number of rows" & OR

MartinDecker_ora-solutionsOct 31 2019 — edited Oct 31 2019

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’

This post has been answered by MartinDecker_ora-solutions on Oct 31 2019

Jump to Answer

Added on Oct 31 2019

#database-key-features, #multitenant

2 comments

1,040 views