Oracle Ora-12008 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 01, 2010 ++++++++++++++++++++++++++++++++++++++++++++++++++++The
Ora-12008: Error In Materialized View Refresh Path Ora-00942: Table Or View Does Not Exist
complete and the most recent version of this article can be ora-12008 error in materialized view refresh path ora-01031 insufficient privileges viewedfrom My Oracle Support Knowledge Section.Master Note for MVIEW 'ORA-' error diagnosis. For Materialized View CREATE or kkzifr3g: encountered error ora-12008 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 applies to any platform.
Ora-12008 Ora-01555
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 follow the links above or use the
Ora-12008 Ora-00942
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 DMDPRODORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457ORA-06512: at "SYS.DBMS_IREFRESH", line 685ORA-06512: at "SYS.DBMS_REFRESH",
with left outer join: CREATE MATERIALIZED VIEW table_mw REFRESH FAST ON COMMIT WITH ROWID AS SELECT v.ROWID v_rid, ora-12008 ora-00913 t.ROWID t_rid, s.ROWID s_rid, v.*,
Oracle Bug Id 13910043
s.dfr, s.dfr FROM table_v v, table_t t, ora-12008 error in materialized view refresh path ora-01555 table_s s WHERE v.ref_id = t.id (+) AND v.ref_id = s.id (+) / CREATE MATERIALIZED VIEW LOG ON table_v WITH ROWID / CREATE MATERIALIZED VIEW LOG ON table_t WITH https://blogs.oracle.com/db/entry/master_note_for_mview_ora-_error_diagnosis_for_materialized_view_create_or_refresh ROWID / CREATE MATERIALIZED VIEW LOG ON table_s WITH ROWID / Now, let's keep aside that not only you have to comply with documented rules for view to be fast refreshable (http://docs.oracle.com/cd/B28359_01/server.111/b28313/basicmv.htm#i1006674), there is also one undocumented restriction: ANSI-joins are not supported. With that solved, we did a simple UPDATE of one row in table TABLE_V. Everything looked fine, until we wanted to commit. Commit returned following error http://michalsimonik.blogspot.com/2015/06/ora-12008-error-in-materialized-view.html stack: ORA-12008: error in materialized view refresh path ORA-00942: table or view does not exist Cause: Table SNAP$_
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more http://stackoverflow.com/questions/19493106/error-in-materialized-view-refresh-path-permission about hiring developers or posting ads with us Stack Overflow Questions Jobs 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 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 error in perform a fast refresh every night prior to another job. The PROC gets called through an automated system (Active Batch), and contains the following 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 error in materialized 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 "Active Batch" workflow automation, it happens again.... Anyone have any idea what I'm missing here? oracle oracle11g materialized-views share|improve this question edited Mar 28 '15 at 16:26 Burhan Ali 1,75711334 asked Oct 21 '13 at 11:18 denisb 32521325 Virtual columns? richardfoote.wordpress.com/2010/11/24/… –David Aldridge Oct 21 '13 at 12:17 Just ran the following from that link and it doesn't appear I have any virtual columns no. –denisb Oct 21 '13 at 13:16 Could it be something as simple as grants going via roles rather than directly to the user? –Colin 't Hart Oct 21 '13 at 15:15 1 Or does this forums.oracle.com/