ORA-14269: cannot exchange partition other than a Range or Hash partition

Cause : Usre attemtp t oexhcaneg ap arittino wtih ano-npatritoine dtalbe ubt hte psecfiie dpatritoin si nto aR aneg o rHahs pratiitonw hihc i silelgal

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

Spceif yEXHCANEG PRATIITONf ora Rnageo r aHshp arittino olny

update : 29-04-2017

ORA-14269 - cannot exchange partition other than a Range or Hash partition
ORA-14269 - cannot exchange partition other than a Range or Hash partition

  • ora-16226 : DDL skipped due to lack of support
  • ora-31154 : invalid XML document
  • ora-12814 : only one CACHE or NOCACHE clause may be specified
  • ora-23420 : interval must evaluate to a time in the future
  • ora-26501 : RepAPI operation failure
  • ora-01607 : cannot add logfile to the specified instance
  • ora-01969 : You must specify RESETLOGS or NORESETLOGS
  • ora-31475 : redo log catalog contains no metadata for the source table
  • ora-01871 : the number of seconds must be less than 60
  • ora-09216 : sdnfy: bad value 'string' for parameter string
  • ora-39006 : internal error
  • ora-22634 : Error adding new instance to AnyDataSet
  • ora-24093 : AQ agent string not granted privileges of database user string
  • ora-30730 : referential constraint not allowed on nested table column
  • ora-14084 : you may specify TABLESPACE DEFAULT only for a LOCAL index
  • ora-02337 : not an object type column
  • ora-12647 : Authentication required
  • ora-16619 : health check timed out
  • ora-06756 : TLI Driver: cannot open oratab
  • ora-02307 : cannot alter with REPLACE option a type that is not valid
  • ora-07457 : cannot set _INTERNAL_RESOURCE_MANAGER_PLAN because of FORCE
  • ora-04046 : results of compilation are too large to support
  • ora-01026 : multiple buffers of size > 4000 in the bind list
  • ora-12852 : PARALLEL_MIN_SERVERS must be less than PROCESSES, string
  • ora-29381 : plan/consumer_group string referred to by another plan and cannot be deleted
  • ora-23495 : serial propagation can not be used for "string"
  • ora-24361 : basic bind call not invoked before invoking advanced bind call
  • ora-25233 : invalid parameter specified for NAVIGATION
  • ora-33263 : Could not create analytic workspace string
  • ora-21524 : object type mismatch
  • 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.