Ora-06512 Error In Materialized View Refresh Path
Contents |
Transpo... » Master Note for MVIEW 'ORA-' error diagnosis. For Materialized View CREATE or REFRESH By LajosV-Oracle on Sep ora-12008: error in materialized view refresh path ora-00942: table or view does not exist 01, 2010 ++++++++++++++++++++++++++++++++++++++++++++++++++++The complete and the most recent version of this ora-12008: error in materialized view refresh path ora-01031: insufficient privileges article can be viewedfrom My Oracle Support Knowledge Section.Master Note for MVIEW 'ORA-' error diagnosis. For Materialized ora-12008 ora-00942 View CREATE or REFRESH (Doc ID 1087507.1)++++++++++++++++++++++++++++++++++++++++++++++++++++ Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.5 to 11.2.0.2.0 - Release: 10.1 to 11.2Information in this document
Ora-12008 Ora-01555
applies to any platform. Purpose How to use this Doc.This article has been created to provide a path to existing My Oracle Support articles that have beenwritten to cover the many possible 'ORA-' related issues that can arise from the creation, refresh andgeneral maintenance of Materialized Views (also know as - Snapshots / MVIEW).Please ora-12008 ora-00913 follow the links above or use the error message you would like a possible solution to as the search criteria (Ctrl-f) within this document.The search will take you to the section that explains the error, and provides links to existing documents (where they exist) in My Oracle Support. These documents have been written from previousoccurance of the error and show the Cause and Solution in each case. Which ORA- error message should I use?The error messages will appear as a single line or part of an error stack. It is a good idea to use thecorrect error as some are just high level errors that are not too important initially. Example 1.ORA-12028: materialized view type is not supported by master site @RKEK2212.EVA.TAO.SE Example 2.ORA-12012: error on auto execute of job 32ORA-12008: error in materialized view refresh path -- These 2 lines are ORA-01008: not all variables bound -- significant hereORA-02063: preceding line from DMDPRO
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the kkzifr3g: encountered error ora-12008 workings and policies of this site About Us Learn more about Stack
Ora-12008: Error In Materialized View Refresh Path Ora-01555: Snapshot Too Old
Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs
Ora-12008: Error In Materialized View Refresh Path Ora-01722: Invalid Number
Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join https://blogs.oracle.com/db/entry/master_note_for_mview_ora-_error_diagnosis_for_materialized_view_create_or_refresh them; it only takes a minute: Sign up Error in materialized view refresh path / permission up vote 2 down vote favorite I have a materalized view I've been using for quite awhile now where I perform a fast refresh every night prior to another job. The PROC gets called through an automated system (Active Batch), and contains the following http://stackoverflow.com/questions/19493106/error-in-materialized-view-refresh-path-permission refresh: DBMS_MVIEW.REFRESH(LIST=>'GLMV_TAX_CODE_HIST',PARALLELISM => 8); A few weeks ago, I randomly began getting this error: Exit Code Description: ORA-12008: error in materialized view refresh path ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2566 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2779 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2748 After a bit of research, figured it was simply a matter of granting permissions based on my findings, so ran the following, which appeared to work: GRANT SELECT ON MLOG$_TAX_CODE_HIST TO MYUSER; GRANT CREATE ANY materialized view to MYUSER; GRANT ALTER ANY MATERIALIZED VIEW TO MYUSER; Grant ALTER ANY SNAPSHOT to MYUSER; Grant create session, alter any materialized view to MYUSER; Figured it might have been an issue with the user I was calling the PROC from, but even after changing it to the creator of the Mview and such, still getting the same error.... Now the strange part is, if I login via client app (Toad) and I run the refresh manually as the same user, it works fine, no errors, but then as soon as I try to call it via "Acti
its alert log and we noticed that it is occurring due http://unixnair.blogspot.com/2013/05/ora-06512-on-materialized-view-refresh.html to a privilege issue. Tue Mar 19 11:14:00 2013 Errors in file /orasw/pmqc1/app/oracle/diag/diag/rdbms/pmqc1/pmqc1/trace/pmqc1_j007_22675516.trc: ORA-12012: error on auto execute of job 103 ORA-12008: error in materialized view refresh path ORA-00942: table or view does not exist ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2563 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2776 ORA-06512: at "SYS.DBMS_IREFRESH", error in line 685 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 Tue Mar 19 11:16:00 2013 Contents of trace file Trace file /orasw/pmqc1/app/oracle/diag/diag/rdbms/pmqc1/pmqc1/trace/pmqc1_j007_22675516.trc Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /orasw/pmqc1/app/oracle/product/11.2.0/db System name: error in materialized AIX Node name: prdmqcx001 Release: 1 Version: 6 Machine: 00F65A334C00 Instance name: pmqc1 Redo thread mounted by this instance: 1 Oracle process number: 109 Unix process pid: 22675516, image: oracle@prdmqcx001 (J007) *** 2013-03-19 11:13:59.952 *** SESSION ID:(2063.11133) 2013-03-19 11:13:59.952 *** CLIENT ID:() 2013-03-19 11:13:59.952 *** SERVICE NAME:(SYS$USERS) 2013-03-19 11:13:59.952 *** MODULE NAME:() 2013-03-19 11:13:59.952 *** ACTION NAME:() 2013-03-19 11:13:59.952 Failed REFRESH STATEMENT /* MV_REFRESH (DEL) */ DELETE FROM "MV_ADMIN"."TEST" SNA$ WHERE "ROW_ID" IN (SELECT /*+ NO_MERGE HASH_SJ */ * FROM (SELECT CHARTOROWID("MAS$"."M_ROW$$") RID$ FROM "ENTERPRISE_TMO_PRODUCTION_NEW _"."MLOG$_TEST" "MAS$" WHERE "MAS$".SNAPTIME$$ > :B_ST0 ) AS OF SNAPSHOT(:B_SCN) MAS$) AND "MARKER" = 1 *** 2013-03-19 11:13:59.992 *** 2013-03-19 11:14:00.001 ORA-12012: error on auto execute of job 103 ORA-12008: error in materialized view refresh path ORA-00942: table or view does not exist ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2563 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2776 ORA-06512: at "SYS.DBMS_IREFRESH", line 685 ORA-0