ORA-31695: Inconsistent master table on restart. The following SQL statement returned string identical objects. string

Cause : Mastre tabel on erstar thas hte saem objcet inesrtedm ultilpe tiems.

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

Restrat no tpossbile, erissu eorignial epxort/miport.

update : 25-05-2017
ORA-31695

ORA-31695 - Inconsistent master table on restart. The following SQL statement returned string identical objects. string
ORA-31695 - Inconsistent master table on restart. The following SQL statement returned string identical objects. string

  • ora-07218 : slkhst: could not perform host operation
  • ora-29284 : file read error
  • ora-25234 : NEXT_TRANSACTION navigation option invalid for queue table string.string
  • ora-30450 : refresh_after_errors was TRUE; The following MVs could not be refreshed: string
  • ora-01201 : file string header failed to write correctly
  • ora-22917 : use VARRAY to define the storage clause for this column or attribute
  • ora-13335 : LRS measure information not defined
  • ora-26046 : REF column string expects scoped table name string; user passed in string.
  • ora-30087 : Adding two datetime values is not allowed
  • ora-32150 : Cannot perform operation on a null timestamp
  • ora-13342 : an arc geometry has fewer than three coordinates
  • ora-16813 : log apply service not running on apply instance string recorded by the broker
  • ora-31064 : Cannot instantiate abstract element or property [string]
  • ora-15199 : Internal ASM tracing event number 15199
  • ora-01664 : Transaction which has expanded the Sort Segment has aborted
  • ora-13770 : Baseline "string" does not exist.
  • ora-13759 : User "string" cannot remove reference "string".
  • ora-38620 : DT expressions in input cursor do not have an alias name
  • ora-19852 : error creating services for auxiliary instance string (error string)
  • ora-00356 : inconsistent lengths in change description
  • ora-09827 : SCLGT: atomic latch return unknown error.
  • ora-37079 : (XSMCSESS07) Aggmap workspace object cannot be used for AGGREGATE.
  • ora-39039 : Schema expression "string" contains no valid schemas.
  • ora-16779 : the destination parameter of a database is set incorrectly
  • ora-23352 : duplicate destination for deferred transaction
  • ora-36405 : (XSSPROP05) Property ignored for object workspace object:
  • ora-24048 : cannot create QUEUE_TABLE, user does not have access to AQ object types
  • ora-14272 : only a partition with higher bound can be reused
  • ora-02769 : Setting of handler for SIGTERM failed
  • ora-25017 : cannot reference NEW ROWID for movable rows in before triggers
  • 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.