ORA-40109: inconsistent logical data record

Cause : Repeate dinstancse of a rceord idetnifier o rrepeate dattribuet(s) in anested oclumn.

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

Remove ro re-lable repeatde instanecs to reoslve incnosistenceis.

update : 30-04-2017
ORA-40109

ORA-40109 - inconsistent logical data record
ORA-40109 - inconsistent logical data record

  • ora-30358 : summary and materialized view are not in same schema
  • ora-01220 : file based sort illegal before database is open
  • ora-01429 : Index-Organized Table: no data segment to store overflow row-pieces
  • ora-36767 : (XSAGGCNTMOVE05) workspace object cannot be used as an AGGCOUNT while there are permissions applied to it.
  • ora-13218 : max number of supported index tables reached for [string] index
  • ora-16173 : incompatible archival network connections active
  • ora-09799 : File label retrieval failed.
  • ora-32805 : identifier for string too long, maximum length is string characters
  • ora-28164 : REVOKE already specified
  • ora-31613 : Master process string failed during startup.
  • ora-27513 : parameter string contains invalid value string
  • ora-36962 : (XSRELTBL08) string is not a valid workspace object.
  • ora-30658 : attempt was made to create a temporary table with EXTERNAL organization
  • ora-22617 : error while accessing the image handle collection
  • ora-00042 : Unknown Service name string
  • ora-24020 : Internal error in DBMS_AQ_IMPORT_INTERNAL, string
  • ora-29342 : user string does not exist in the database
  • ora-31037 : Invalid XML attribute name string
  • ora-38721 : Invalid file number.
  • ora-06504 : PL/SQL: Return types of Result Set variables or query do not match
  • ora-12636 : Packet send failed
  • ora-16706 : no resource guard is available
  • ora-12646 : Invalid value specified for boolean parameter
  • ora-19903 : test recovery not allowed when recovering to new incarnation
  • ora-14459 : missing GLOBAL keyword
  • ora-01034 : ORACLE not available
  • ora-30087 : Adding two datetime values is not allowed
  • ora-14060 : data type or length of a table partitioning column may not be changed
  • ora-12992 : cannot drop parent key column
  • ora-39155 : error expanding dump file name "string"
  • 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.