Hi Everyone,

I've set up a refresh group and Materialized Views using remote MV logs on the source database.

I'm trying to understand the errors I'm getting on one environment when the refresh has been started by calling a procedure via an application server.

ORA-12048: error encountered while refreshing materialized view MY_MV
ORA-01013: user requested cancel of current operation

I believe that the refresh took a long time and caused the application to cancel the refresh due to a timeout on the application server and the cause of the ORA-12048 is actually the second error ORA-01013.

Am I correct in thinking the second error is what cause the refresh error?

Many thanks,

Aron