-
Understanding Oracle Errors
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
-
Sounds logical. Has this refresh worked before?
MV has a very strict requirement for refresh, you may want to check if all requirements are met.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|