看下这个SQL

SELECT DBLINK, NVL(DISABLED, 'F'), FLAG FROM SYSTEM.DEF$_DESTINATION;
复制

有可能是bug：Materialized View Refresh Fails with ORA-1422 When Duplicate Entry in SYSTEM.DEF$_DESTINATION Table (Doc ID 2172529.1)

或者是你用10046跟踪下，看是那句SQL报错了。

大佬 这个是有输出的SQL

(1) MView refresh will fail with the error ORA-1422.

exec dbms_mview.refresh(‘TEST_MV’, ‘C’)
Error report -
ORA-01422: exact fetch returns more than requested number of rows

The duplicate entry in this table “SYSTEM.DEF$_DESTINATION” is causing the problem.

按照这个来做吧，需要删其中一条数据

1. Create a backup copy of the table "SYSTEM.DEF$_DESTINATION" (just to be on safer side).
2. Delete one of the duplicate rows from the table "SYSTEM.DEF$_DESTINATION".
3. Commit the change.

4. Again re-run the below query and you should get the output as given below and make sure there are no duplicate rows.
SQL> column dblink format a30;
SQL> SELECT DBLINK, NVL(DISABLED, 'F'), FLAG FROM SYSTEM.DEF$_DESTINATION;

5. Re-run the MV refresh and check if it throws ORA-1422 error.
复制

感谢大佬 可以了

管用，谢谢大佬！