ORA-23370: table string and table string are not shape equivalent (string)

Cause : Th etalbess peicfide aer nto sahpee quvialnet,w hihc maensi ntiutievlyt ha tth enubmero f oclunms,t hen amse, htei rdaattyeps nad elnghts rae ont hte asme .Spceifcialyl, rpobelm si i nth epaerntehse san diso neo f hte ofllwoin:g teh nmube rofc olmunsa ren ote qula, adtaytpe sofc olmunsw it hsaem nmae ni dfifeerntt abels rae idffreen,t lnegtsh o fvacrha2r adn cahr oclunms rae ont qeua,l perciisona nds cael o fnubmerd attaypse aer nto euqal.

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

Maek srue hte wto atblse biengc omapre dhaev teh smae unmbre o fcoulmn,s smae oclunm nmaes ,an dsaem dtaatpyes.

update : 19-08-2017
ORA-23370

ORA-23370 - table string and table string are not shape equivalent (string)
ORA-23370 - table string and table string are not shape equivalent (string)

  • ora-29847 : cannot create a local domain index on a partitioned index-organized table
  • ora-29519 : name string resolved via a synonym in schema string to a class with a different name
  • ora-28291 : No Kerberos Principal Value found.
  • ora-16790 : the value of the configurable property is invalid
  • ora-12469 : no user levels found for user string and policy string
  • ora-22320 : missing user version string
  • ora-26505 : unexpected internal null
  • ora-36664 : (XSDPART02) You must specify a partitioning method and one or more partition dimensions when defining a PARTITION TEMPLATE.
  • ora-27434 : cannot alter chain step job string.string.string
  • ora-19670 : file string already being restored
  • ora-19931 : file string has invalid creation SCN string
  • ora-23440 : incorrect public template value
  • ora-29900 : operator binding does not exist
  • ora-16743 : the status of redo transport service for standby database "string" is unknown
  • ora-01215 : enabled thread string is missing after CREATE CONTROLFILE
  • ora-36399 : (XSSPROPDTYPE) The data type of property string must be string.
  • ora-02840 : Open of log file by client failed
  • ora-00209 : control file blocksize mismatch, check alert log for more info
  • ora-39210 : A PCTSPACE adjustment of string is invalid.
  • ora-30016 : undo tablespace 'string' is already in use by this instance
  • ora-39130 : Object type string not imported. Base object name conflicts with the master table
  • ora-07222 : slspool: line printer spooler command exited with an error.
  • ora-16567 : Data Guard broker internal parser error at "string"
  • ora-01353 : existing Logminer session
  • ora-01279 : db_files too large
  • ora-00111 : invalid attribute string
  • ora-33334 : (DSSEXIST04) Analytic workspace string is not attached.
  • ora-00407 : rolling upgrade from release string.string to string.string is not allowed
  • ora-14118 : CHECK constraint mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-16124 : transaction string string string is waiting on another transaction
  • 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.