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 : 26-06-2017

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

  • ora-09956 : scgcm: unexpected lock status condition
  • ora-07704 : error in archive text: need ':' after device name
  • ora-30020 : UNDO_MANAGEMENT=AUTO needs Compatibility string or greater
  • ora-01908 : EXISTS keyword expected
  • ora-01945 : DEFAULT ROLE[S] already specified
  • ora-30392 : the checksum analysis for the rewrite equivalence failed
  • ora-37042 : (XSACQUIRE_DEP_DEADLOCK) Cannot wait to acquire composite, concat, dimension map, or internal partition workspace object since doing so would cause a deadlock.
  • ora-28590 : agent control utility: illegal or badly formed command
  • ora-06807 : TLI Driver: could not open ethernet device driver file
  • ora-07460 : cannot set the RESOURCE_MANAGER_PLAN parameter
  • ora-06254 : NETNTT: cannot share connection to cube
  • ora-00200 : control file could not be created
  • ora-09759 : osnsbt: bad message received.
  • ora-03293 : Cluster to be truncated is a HASH CLUSTER
  • ora-22620 : buffer size too small to hold the value
  • ora-24320 : unable to initialize a mutex
  • ora-24393 : invalid mode for creating connection pool
  • ora-00021 : session attached to some other process; cannot switch session
  • ora-07508 : scgfal: $deq all unexpected return
  • ora-16146 : standby destination control file enqueue unavailable
  • ora-13125 : partition key is already set
  • ora-13032 : Invalid NULL SDO_GEOMETRY object
  • ora-02172 : The PUBLIC keyword is not appropriate for a disable thread
  • ora-16514 : the request was not found
  • ora-28540 : internal result set error
  • ora-30928 : Connect by filtering phase runs out of temp tablespace
  • ora-28501 : communication error on heterogeneous database link
  • ora-24337 : statement handle not prepared
  • ora-36921 : (XSVPMVTOPART02) workspace object and workspace object are not in the same analytic workspace.
  • ora-27064 : cannot perform async I/O to file
  • 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.