ORA-12097: changes in the master tables during refresh, try refresh again

Cause : Three rae osmec hagnes( i..e, ocnvnetinoalD ML ,dierctl oa,d pratiitonm aitnennaceo peartino) ni teh msate rtalbesd urnig amteiralziedv ie wrerfes.h

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Rerfes hth eafefctde mtaerailiezd ivew sagian.

update : 25-04-2017
ORA-12097

ORA-12097 - changes in the master tables during refresh, try refresh again
ORA-12097 - changes in the master tables during refresh, try refresh again

  • ora-16244 : taking checkpoint and paging out string bytes to disk
  • ora-00471 : DBWR process terminated with error
  • ora-01103 : database name 'string' in control file is not 'string'
  • ora-07240 : slemrd: seek error.
  • ora-29961 : too many warnings occurred in the execution of ODCIIndex DDL routine
  • ora-39106 : Worker process string failed during startup. Worker error:
  • ora-09292 : sksabln: unable to build archive file name
  • ora-14185 : incorrect physical attribute specified for this index partition
  • ora-08115 : can not online create/rebuild this index type
  • ora-10914 : invalid TABLESPACE GROUP clause
  • ora-25461 : rule set not specified
  • ora-29369 : invalid method name string specified for consumer group string
  • ora-12520 : TNS:listener could not find available handler for requested type of server
  • ora-40306 : wide data not supported for decision tree model create
  • ora-19375 : no CREATE TABLE privilege on schema "string"
  • ora-16656 : higher DRC UID sequence number detected
  • ora-07704 : error in archive text: need ':' after device name
  • ora-14632 : cannot specify PARALLEL clause when adding a List subpartition
  • ora-19563 : %s header validation failed for file string
  • ora-30186 : '' must be followed by four hexdecimal characters or another ''
  • ora-13237 : internal error during R-tree concurrent updates: [string]
  • ora-39955 : invalid PL/SQL warning message number
  • ora-01019 : unable to allocate memory in the user side
  • ora-37602 : (XSPGERRTEMPUSER) Ran out of temporary storage while writing to analytic workspace string. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-02829 : No segment of the proper size is available
  • ora-25190 : an index-organized table maintenance operation may not be combined with other operations
  • ora-29533 : attempt to overwrite class or resource string while defining or compiling string.string
  • ora-06254 : NETNTT: cannot share connection to cube
  • ora-24122 : invalid block range specification
  • ora-40289 : duplicate attributes provided for data mining function
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.