DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Understanding Oracle Errors

Hybrid View

  1. #1
    Join Date
    Mar 2021
    Posts
    1

    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

  2. #2
    Join Date
    Dec 2002
    Posts
    74
    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
  •  


Click Here to Expand Forum to Full Width