ORA-14315: cannot merge a partition with itself

Cause : hT easemp raititnon ma eaw spscefiei dwtci eof rht eemgr eporetaoin

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

eRs-buim tporetaoi niwht2 d siitcn taptrtioi nanems

update : 17-08-2017
ORA-14315

ORA-14315 - cannot merge a partition with itself
ORA-14315 - cannot merge a partition with itself

  • ora-02183 : valid options: ISOLATION_LEVEL { SERIALIZABLE | READ COMMITTED }
  • ora-06431 : ssaio: Invalid Block number
  • ora-24038 : RETRY_DELAY and MAX_RETRIES cannot be used for a 8.0 compatible multiple consumer queue
  • ora-30570 : SEGMENT SPACE MANAGEMENT option already specified
  • ora-10657 : Lob column to be shrunk does not exist
  • ora-14613 : Attempt to generate name from parent name string and template name string failed as the combine named would have been longer than allowed
  • ora-15082 : ASM failed to communicate with database instance
  • ora-21611 : key length [string] is invalid
  • ora-28504 : ROWID not found in ROWID cache for heterogeneous database link
  • ora-01169 : DATAFILE number 1 not found. Must be present
  • ora-03127 : no new operations allowed until the active operation ends
  • ora-13120 : invalid face_id [string]
  • ora-13438 : GeoRaster metadata pyramid type error
  • ora-02375 : conversion error loading table string.string partition string
  • ora-07841 : sllfop: SYS$OPEN failure
  • ora-12827 : insufficient parallel query slaves available
  • ora-01932 : ADMIN option not granted for role 'string'
  • ora-19502 : write error on file "string", blockno string (blocksize=string)
  • ora-32822 : subscriber string is marked for removal
  • ora-07513 : sscgctl: $deq unexpected return on cancel of term. lock
  • ora-02335 : invalid datatype for cluster column
  • ora-16117 : processing
  • ora-19505 : failed to identify file "string"
  • ora-01374 : _log_parallelism_max greater than 1 not supported in this release
  • ora-27454 : argument name and position cannot be NULL
  • ora-00054 : resource busy and acquire with NOWAIT specified
  • ora-00962 : too many group-by / order-by expressions
  • ora-00265 : instance recovery required, cannot set ARCHIVELOG mode
  • ora-24011 : cannot drop QUEUE, string should be stopped first
  • ora-28591 : agent control utility: unable to access parameter 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.