Ora-12008 Error In Materialized View Refresh Path Insufficient Privileges
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss ora-12008: error in materialized view refresh path ora-00942: table or view does not exist the workings and policies of this site About Us Learn more ora-12008 ora-00942 about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow ora-12008 ora-00913 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
Ora-12008 Ora-01555
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 perform a fast refresh every night prior to another job. The PROC gets called through an automated system (Active Batch), ora-06512: at line 2563 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 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 so
refresh path [message #214198] Mon, 15 January 2007 06:48 Anand Ramaswamy Messages: 111Registered: January 2005 Senior Member Hi All, I have posted the same problem ora-12008: error in materialized view refresh path ora-01722: invalid number in PL/SQL Expert Forum, but did not get any response so posting
Ora-12008: Error In Materialized View Refresh Path Ora-01555: Snapshot Too Old
it here. Very often I could see the below list of error messages in the alert.log What
Oracle Bug Id 13910043
could be the problem? Error Message: Wed Jan 10 10:26:56 2007 ...skipping... ORA-12008: error in materialized view refresh path ORA-08103: object no longer exists ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 http://stackoverflow.com/questions/19493106/error-in-materialized-view-refresh-path-permission ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 Wed Jan 10 15:53:26 2007 I do not get the error when I try to refresh the same materialized view using SQL> execute dbms_refresh.refresh('"DEVELOPMENT"."DEV_BLUE_BOOK_YIELD_REP_MV"'); Please help. Thanks in advance qA Report message to a moderator Re: http://www.orafaq.com/forum/t/75328/ error in materialized view refresh path [message #214201 is a reply to message #214198] Mon, 15 January 2007 06:57 tahpush Messages: 961Registered: August 2006 Location: Stockholm/Sweden Senior Member There are some good hint here Do a find for ORA-08103 on that page, and you'll find some thoughts about your issue. Good Luck Report message to a moderator Previous Topic: Documenting an existing data model Next Topic: Getting an "ORA-01031: insufficient privileges" error occasionally Goto Forum: - SQL & PL/SQLSQL & PL/SQLClient Tools- RDBMS ServerServer AdministrationBackup & RecoveryPerformance TuningSecurityNetworking and GatewaysEnterprise ManagerServer Utilities- Server OptionsRAC & FailsafeData GuardReplicationStreams & AQSpatialText & interMedia- Developer & ProgrammerApplication Express, ORDS & MOD_PLSQLFormsReports & DiscovererDesignerJDeveloper, Java & XMLWarehouse BuilderPrecompilers, OCI & OCCI- Fusion Middleware & Colab SuiteWeblogic & Application ServerBusiness IntelligenceWebCenter Suite & PortalCollaboration & Content ManagementSOA Suite, BPEL and OWSM- ApplicationsOracle Fusion Apps & E-Business SuitePeopleSoft, JD Edwards & SiebelPrimaveraOther Application Suites- InfrastructureHardwareUnixLinuxWindowsOther Operating Systems- Open SourceProgramming InterfacesMySQL- OtherGeneralTraining & CertificationMarketplaceCommunity HangoutSuggestions & FeedbackTest- Non-English ForumsArabicDutchFrenchGermanJapanesePortugueseRussianSpanish -=] Back to Top [
created a materialized view, but during the corresponding job running, an error http://www.dw4e.com/?p=99 occurred. The following text is the error message in http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=17363 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 on auto execute of job 225
ORA-12008: error in materialized view refresh path
ORA-01031: insufficient privileges
error in 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 error in materialized 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 EMAIL Website URL NOTE - You can use these HTML tags and attributes:
RSS Feed Recent Posts 在阿里云Linux上安装Mongo DB 3.0 Oracle不同字符集的dblink乱码问题解决办法 Hive Impala Presto, comparison of performance Hive Impala Presto, comparison of functionality Presto的单节点和多节点配置 Search by Tags! aggregation audit a
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 SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Forum All threads Best last month Links Oracle official Oracle Technical Info Tools (free) Tools (commercial) Oracle FAQ Other DBA-sites Oracle development Not Oracle 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 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 StatisticsEver registered users47788Total active users2117Act. users last 24h9Act. users last hour0Registered 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 T and then issues a c