Ora-12008 Error In Materialized View Refresh Path Ora-01031 Insufficient Privileges
Contents |
Transpo... » Master Note for MVIEW 'ORA-' error diagnosis. For Materialized View CREATE or REFRESH By LajosV-Oracle on Sep 01, 2010 ++++++++++++++++++++++++++++++++++++++++++++++++++++The complete and the most recent
Ora-12008: Error In Materialized View Refresh Path Ora-00942: Table Or View Does Not Exist
version of this article can be viewedfrom My Oracle Support Knowledge Section.Master ora-12008 error in snapshot refresh path Note for MVIEW 'ORA-' error diagnosis. For Materialized View CREATE or REFRESH (Doc ID 1087507.1)++++++++++++++++++++++++++++++++++++++++++++++++++++ Applies to: Oracle Server
Ora-12008 Ora-00942
- 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. Purpose How to use this Doc.This article has been created ora-12008 ora-00913 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 error message you would like a possible solution to as the search criteria (Ctrl-f) within ora-06512: at line 2563 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", line 195 Scope and Application This is article is intended for DBA's, Users and Support Engineers who have received an ORA- type error when running, refreshing or creating Materialized Vi
Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Scripts Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Papers Administration ORA-HOWTO Web and Mobile
Ora-12008 Ora-01555
SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Forum All ora-12008: error in materialized view refresh path ora-01722: invalid number threads Best last month Links Oracle official Oracle Technical Info Tools (free) Tools (commercial) Oracle FAQ Other DBA-sites Oracle development Not Oracle
Oracle Error In Materialized View Refresh Path
specific Oracle Blogs Imho Fqa Pirats | Start a new thread | All threads | Best last month | Question Most of my databases are on version 12.1 11.2 11.1 10.2 10.1 or lower Answer and https://blogs.oracle.com/db/entry/master_note_for_mview_ora-_error_diagnosis_for_materialized_view_create_or_refresh see the results DBA Top 10 1 M. Cadot 35800 2 F. Diaz 34000 3 J. Schnackenberg 16400 4 B. Vroman 15450 5 A. Kavsek 15250 6 P. Wisse 14250 7 T. Boles 13500 8 M. Hidayathullah ... 10900 9 A. Hudspith 9200 10 A. Khan 4100 About Advertise here Download PLATOThe free tool for auditing and tuning your databaseVersion 55 now available Sep 02, 2016 The DBA-Village forum as RSS feed Site http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=17363 StatisticsEver registered users47788Total active users2117Act. users last 24h9Act. users last hour1Registered user hits last week756Registered user hits last month6432 Go up Materialized View refresh on commit failure (ORA-12008 & 1031) Next thread: logon-trigger Prev thread: Database migration from 8174 to 10201 Message Score Author Date All, I have two users, X & Y. User X creates a ...... Alister Brown Mar 08, 2006, 17:12 Hi Alister, User X does not have any permission...... Shailandra Vaish Mar 08, 2006, 17:36 That's all very well, but is ot possible to grant ...... Alister Brown Mar 08, 2006, 18:04 Follow up by mail Click here Subject: Materialized View refresh on commit failure (ORA-12008 & 1031) Author: Alister Brown, United Kingdom Date: Mar 08, 2006, 17:12, 3882 days ago Os info: AIX 5.2 Oracle info: 9.2.0.5 Error info: ORA-12008: error in materialized view refresh path ORA-01031: insufficient privileges Message: All, I have two users, X & Y. User X creates a table T and a materialised view log on it that includes the rowid & primary key, then grants select privileges on T to Y. User Y creates a simple materialised view against T that includes the refresh fast on commit & build immediate options. At this point all is ok. However, when user X attempts to update a column in
created a http://www.dw4e.com/?p=99 materialized view, but during the corresponding job running, an error occurred. The following text is the error message in the Oracle alert file:
Mon Aug 13 19:00:54 2012
Errors in file /opt/oracle/admin/dacdb/bdump/dacdb_j000_20861.trc:
ORA-12012: error in error on auto execute of job 225
ORA-12008: error in materialized view refresh path
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457
ORA-06512: at "SYS.DBMS_IREFRESH", line 685
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
The materialized view was created by a DBA user, but why still "insufficient privileges"? Finally I found the solution: Grant a dba role to the user is USELESS! The privileges must be EXPLICITLY granted! eg:
GRANT SELECT ON dw_meta.md_dw_cbu_indicator_info TO CBU_DP;
GRANT SELECT ON dw_meta.md_dw_cbu_table_info TO CBU_DP;
GRANT SELECT ON dw_meta.md_dw_cbu_report TO CBU_DP;
Data Warehouse For Ever原创文章,转载请注明出处 Oracle ← 关于Apache Hadoop 1.0 RHEL上安装Node.js → Leave a comment ?1 Comments. Bert 2016-06-07 at 2:28 am It was dark when I woke. This is a ray of sunnsihe. Leave a Comment Cancel reply NAME