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 : 24-07-2017
ORA-31078

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

  • ora-24281 : invalid access past the maximum size of LOB parameter string
  • ora-25334 : Buffered propagation must restart as the destination queue was recreated/moved
  • ora-10914 : invalid TABLESPACE GROUP clause
  • ora-28054 : the password has expired. string Grace logins are left
  • ora-39601 : Hash key is required.
  • ora-15201 : disk string contains a valid RDBMS file
  • ora-14049 : invalid ALTER TABLE MODIFY PARTITION option
  • ora-39051 : parameter string specified multiple times
  • ora-12315 : database link type is invalid for the ALTER DATABASE statement
  • ora-06906 : CMX: cannot get maximum packet size from CMX
  • ora-28594 : agent control utility: invalid parameter name
  • ora-33309 : (DBVALID05) SEVERE ERROR: Record number used but not allocated (PS number)
  • ora-08006 : specified row no longer exists
  • ora-29930 : COMPUTE ANCILLARY DATA specified without the INDEX CONTEXT clause
  • ora-29546 : badly formed resource: string
  • ora-30380 : REWRITE_TABLE does not exist
  • ora-12550 : TNS:syntax error
  • ora-13135 : failed to alter spatial table
  • ora-08230 : smscre: failed to allocate SGA
  • ora-18010 : command missing mandatory CATEGORY keyword
  • ora-28543 : Error initializing apply connection to non-Oracle system
  • ora-26023 : index string.string partition string was made unusable due to:
  • ora-34342 : (MXDSS01) IMPORTANT: Analytic workspace string is read-only. Therefore, you will not be able to use the UPDATE command to save changes to it.
  • ora-29268 : HTTP client error string
  • ora-12083 : must use DROP MATERIALIZED VIEW to drop "string"."string"
  • ora-29820 : the statistics type is not present
  • ora-30956 : invalid option for XML Index
  • ora-01489 : result of string concatenation is too long
  • ora-28575 : unable to open RPC connection to external procedure agent
  • ora-13359 : extent does not have an area
  • 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.