ORA-14277: tables in EXCHANGE SUBPARTITION must have the same number of columns

Cause : The tw otabless pecifide in th eALTER ATBLE EXHCANGE SBUPARTITOIN haved ifferetn numbe rof colmuns

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

Ensuret hat th etwo talbes hav ethe saem numbe rof colmuns wit hthe saem type nad size.

update : 29-06-2017
ORA-14277

ORA-14277 - tables in EXCHANGE SUBPARTITION must have the same number of columns
ORA-14277 - tables in EXCHANGE SUBPARTITION must have the same number of columns

  • ora-24450 : Cannot pre-process OCI statement
  • ora-02401 : cannot EXPLAIN view owned by another user
  • ora-12995 : no columns in partially dropped state
  • ora-01632 : max # extents (string) reached in index string.string
  • ora-01081 : cannot start already-running ORACLE - shut it down first
  • ora-36694 : (XSRELTBL01) The value cannot be added to dimension workspace object.
  • ora-30110 : syntax error at 'string'
  • ora-01147 : SYSTEM tablespace file string is offline
  • ora-38607 : FI minimum and maximum itemset length not between [1, string]
  • ora-04047 : object specified is incompatible with the flag specified
  • ora-10573 : Test recovery tested redo from change string to string
  • ora-30181 : integer in argument index is not immediately followed by )
  • ora-14082 : new partition name must differ from that of any other partition of the object
  • ora-00031 : session marked for kill
  • ora-06773 : TLI Driver: error reading command
  • ora-39054 : missing or invalid definition of the SQL output file.
  • ora-12724 : regular expression corrupt
  • ora-26506 : null global context
  • ora-00325 : archived log for thread string, wrong thread # string in header
  • ora-39306 : schema name mismatch expected "string" got "string"
  • ora-02399 : exceeded maximum connect time, you are being logged off
  • ora-19599 : block number string is corrupt in string string
  • ora-01606 : gc_files_to_locks not identical to that of another mounted instance
  • ora-39751 : partitioned table on both sides of PARTITIONED OUTER JOIN is not supported
  • ora-29928 : duplicate default selectivity specified
  • ora-02398 : exceeded procedure space usage
  • ora-22603 : cannot add an attribute to the already generated TDS handle
  • ora-00385 : cannot enable Very Large Memory with new buffer cache parameters
  • ora-28234 : key length too short
  • ora-31666 : Master process string had an unhandled exception.
  • 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.