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 : 23-08-2017
ORA-31078

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

  • ora-13210 : error inserting data into the index table
  • ora-00283 : recovery session canceled due to errors
  • ora-33219 : (CINSERT05) %K cannot be added to workspace object because it is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.
  • ora-14510 : can specify VALIDATE INTO clause only for partitioned tables
  • ora-39173 : Encrypted data has been stored unencrypted in dump file set.
  • ora-37112 : OLAP API requires Oracle 9.2 or later
  • ora-01157 : cannot identify/lock data file string - see DBWR trace file
  • ora-09344 : spsig: error signalling thread
  • ora-13462 : invalid blocking specification
  • ora-24342 : unable to destroy a mutex
  • ora-23606 : invalid object string
  • ora-01663 : the contents of tablespace 'string' is constantly changing
  • ora-24377 : invalid OCI function code
  • ora-39086 : cannot retrieve job information
  • ora-24772 : Cannot mix tightly-coupled and loosely-coupled branches
  • ora-28349 : cannot encrypt the specified column recorded in the materialized view log
  • ora-02141 : invalid OFFLINE option
  • ora-21705 : service context is invalid
  • ora-30084 : invalid data type for datetime primary with time zone modifier
  • ora-24089 : AQ Agent string already exists
  • ora-02292 : integrity constraint (string.string) violated - child record found
  • ora-36273 : (XSCGMDLAGG12) Dimension workspace object appears more than once in the QDR.
  • ora-29918 : cannot create domain indexes on temporary tables
  • ora-04010 : the number of values to CACHE must be greater than 1
  • ora-28521 : no heterogeneous capability information available
  • ora-24355 : attempt to store a negative number in an Unsigned Display type.
  • ora-09980 : skxfqdrcv: Error Receiving a message from another endpoint
  • ora-22631 : attribute [string] is is not well-formed or does not match the type
  • ora-01274 : cannot add datafile 'string' - file could not be created
  • ora-25140 : %s space policy cannot be specified for the string extent management
  • 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.