Error Encountered Ora-10980
Member No.: 43,832 In Trace file I am always geeting one error "Error encountered: ORA-10980" due to which MVs fails . Could you please let me know how to overcome from this error? burleson View Member Profile Oct 19 2010, 09:17 AM Post #2 Advanced Member Group: Members Posts: 13,227 Joined: 26-January 04 Member No.: 13 >> Could you please let me know how to overcome from this error?This may have something to do with direct permissions granted to an MV creator vs through roleQUOTE ORA-10980: prevent sharing of parsed query during Materialized View query generation Cause: Not found in Oracle Documentation . Action: Not found in Oracle Documentation .Like it says, open a service resquest with MOSC, and search MOSC for "ORA-10980":http://support/oracle.com -------------------- Hope this helps. . . Donald K. BurlesonOracle Press authorAuthor of Oracle Tuning: The Definitive Reference SteveC View Member Profile Oct 19 2010, 10:26 AM Post #3 Advanced Member Group: Members Posts: 2,836 Joined: 11-March 08 Member No.: 18,933 Oracle views this as an internal error not meant to be seen by users (depending upon where it occurs). One of the causes is when a MV is based on another MV. There is a patch to fix this, but it's also supposed to be fixed in 12.1. Other solutions include flushing the shared pool before the statement and matching up user versus role. « Next Oldest · Oracle Forum · Next Newest » 1 User(s) are reading this topic (1 Guests and 0 Anonymous Users) 0 Members: Forum Home Search Help Oracle |-- Oracle Forum Display Mode: Standard · Switch to: Linear+ · Switch to: Outline Track this topic · Email this topic · Print this topic · Subscribe to this forum Lo-Fi Version Time is now: 11th October 2016 - 04:50 AM Powered By Invision IPB © 2016 IPS, Inc.
trace file after attempting to alter materialized view? From: g3000
always geeting one error "Error encountered: ORA-10980" due to which MVs fails . how to overcome from this error? Tags: Related Articles BB Bold :: http://www.labhc.com/trace-file-mvs-failed-ora-10980-error-encountered/ Synchronization Fails Because Of "Error Encountered. Error Code - 0x80043ac9 Check Documentation"( 0 https://community.oracle.com/thread/2280778 ) Photoshop Elements :: Catalog Backup Error Encountered While Writing File( 0 ) Ubuntu Installation :: Installation Failed 10.04 - Installed Encountered An Unrecoverable Error?( 0 ) RAC 10g Error Found In Trace File?( 0 ) Truncate Statement Failing Randomly With ORA-03291 Error( 0 ) General :: Rsync Error: IO Error error encountered Encountered - Skipping File Deletion?( 0 ) Server Administration :: ORA-01116 / Error In Opening Database File 26( 1 ) Server Administration :: ORA-01565 / Error In Identifying File( 1 ) 3ds Max :: Error / File Open Failed( 1 ) Latest Articles ActionScript 2.0 :: Select All The Text In Textarea? Add Combobox For One Cell Into Datagrid? Rolling Formulas In VBA error encountered ora-10980 Find And Replace Cell That Are Blank With The Dash ActionScript 2.0 :: CS3 Sub Movieclip Access? Actionscript 3 :: Call The Function That Is In Main.mxml App From A Class In Flex Recent Articles 12-hour Time Entry Stored As Text Multiple Page Break AJAX :: 4 Nested Accordions And Radiobuttonlist - Cannot Get The Value Of The Radio Button Safari Can't Open Because Server Has Stopped Responding Stop From Asking To Log Into ITunes Random article STAY Away From Startlogic April 13 0 Software :: Unable To Read CD? August 16 0 Adding Carriage Return Character To String October 21 0 General :: Installing Evolution Email Program - Cannot Get It To Run October 3 0 C# - How To Let Web-user-control Determine Automatically The URL Of The Page November 30 0 Tagsga74gm-s2h no sound adding sections to bbm group nokia e72 disable reminders slackware linvo Animated screnlock for nokia E72 nokia e72 quarlar idd not found Nokia E52 disk full acer aspire r3 froze on hibernation acer v15 nitro black edition shutdown opera min for blackberry 9865 download Copyright © 2016 labhc.com webmaster#labhc.com 17 q. 1.158
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 5 Replies Latest reply on Sep 7, 2011 12:37 PM by 886438 CREATE MV ON PREBUILT TABLE uses up all UNDO; why? 874986 Sep 6, 2011 6:23 AM Hi, We have a DW application with star schemas and a few MVs. Our MVs are on top of prebuilt tables as we "manually" manage the aggregations. Creation of most of the MV definitions over the prebuilt tables is OK: they take just a few hundred milliseconds as expected when only the data dictionary is updated. But there is one MV which takes a lot of time (hours) to create and eventually it fails when it used up all UNDO (no matter how much we extend UNDO). This does not make sense at all. The facts and my observations: - 10gR2 EE with Partitioning - The problematic prebuilt table is range partitioned (by calendar week), no indexes. The problem-free prebuilt tables are also range partitioned (same logic) and have a bitmap index on the partition key column (DATE datatype). - Base table is range partitioned (by calendar week) with indexes and an MV log that is used by a single Oracle-managed MV. MV log is assumed to be OK. - Adding a bitmap index on the partition key column of the problematic table did not fix the issue. - In schemas with the same application installed but with a small amount of data, the creation of this MV takes longer than the expected few hundred milliseconds, but it is under 10 minutes (mostly under 3 minutes). After the successful creation only the expected objects (table (partitions) and MV) can be seen in user_objects. - MV creation worked for a while until amount of data in prebuilt table reached a certain size. - The MV definition is correct: same object name and same column structure as prebuilt table, MV is then used in queries producing correct results. - When the CREATE MV ON PREBUILT TABLE is being executed, all available UNDO is allocated until there is no more space in tablespace. - TEMP does not seem to be used - No new object or segment can be seen. - Execution of CREATE MV is done in parallel (32 PXs); all I could observe is that there was a "+db file sequential read+" from the data tablespace and 32 "+PX Deq Credit: send blkd+" o