We've a small 19c database with six materialized views, some of which refresh nightly via a database link to another system. Two stopped refreshing recently with the error below:
ORA-02245: invalid ROLLBACK SEGMENT name
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3020
ORA-06512: at "SYS.DBMS_TRANSACTION", line 74
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2842
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3263
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3322
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 44
ORA-06512: at "SYS.DBMS_IREFRESH", line 1177
ORA-06512: at "SYS.DBMS_REFRESH", line 263
We can find no real information on addressing this issue or its cause.
If we amend the PL/SQL called from the DBMS Job that invokes the refresh from
dbms_refresh.refresh('"OWNER"."MVNAME"') to dbms_mview.refresh('"OWNER"."MVNAME"')
the job runs fine. Clearly the dbms_mview.refresh is working where the dbms_refresh isn't.
Has anyone seen this issue before or care to offer an informed opinion on it?