ORA-31078: error in SQL mapping information

Cause : There i san erro rin the QSL type nad tables pecifictaion witihn the XLM Schema.

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

Ensure htat all psecifiedS QL type sand tabels are vlaid and ocmpatibl ewith th ecorrespnoding XM Ltypes.

update : 29-04-2017
ORA-31078

ORA-31078 - error in SQL mapping information
ORA-31078 - error in SQL mapping information

  • ora-13762 : The string ranking measure is invalid.
  • ora-40219 : apply result table string is incompatible with current operation
  • ora-06029 : NETASY: port assignment failure
  • ora-38727 : FLASHBACK DATABASE requires a current control file.
  • ora-06022 : NETASY: channel open failure
  • ora-27375 : valid agent name must be specified for secure queues
  • ora-13270 : OCI error string
  • ora-24418 : Cannot open further sessions.
  • ora-28042 : Server authentication failed
  • ora-00293 : control file out of sync with redo log
  • ora-12024 : materialized view log on "string"."string" does not have primary key columns
  • ora-28005 : invalid logon flags
  • ora-10651 : incorrect file number block number specified
  • ora-19694 : some changed blocks were not found in the change tracking file
  • ora-26714 : User error encountered while applying
  • ora-16623 : stale DRC UID sequence number detected
  • ora-12841 : Cannot alter the session parallel DML state within a transaction
  • ora-26004 : Tables loaded through the direct path may not be clustered
  • ora-16658 : unobserved Fast-Start Failover configuration
  • ora-16102 : remote information is not available on the specified primary
  • ora-00279 : change string generated at string needed for thread string
  • ora-40106 : positive target value not specified for computing Lift
  • ora-30432 : summary 'string.string' is in INVALID state
  • ora-31180 : DOM Type mismatch in invalid PL/SQL DOM handle
  • ora-08119 : The new initrans will make the index too big
  • ora-30185 : output too large to fit in the buffer
  • ora-06700 : TLI Driver: incorrect message type from host
  • ora-31658 : specifying a schema name requires a table name
  • ora-13294 : cannot transform geometry containing circular arcs
  • ora-38774 : cannot disable media recovery - flashback database is enabled
  • 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.