Due to some limitation one of my database is Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 which was recently crashed and imported again. After that none of my MV are getting refreshed due to ora-01422 error. One test scenario is shown below
SQL> exec dbms_mview.refresh('EDB.EMP_SENIORITY_MAS');
begin dbms_mview.refresh('EDB.EMP_SENIORITY_MAS'); end;
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2558
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2771
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2740
ORA-06512: at line 1
Since it is very outdated DB, but any help would be grateful.