ORA-14274: partitions being merged are not adjacent

Cause : User attempt to merge two partitions that are not adjacent to each other which is illegal

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

Specify two partitions that are adjacent

update : 23-08-2017
ORA-14274

ORA-14274 - partitions being merged are not adjacent
ORA-14274 - partitions being merged are not adjacent

  • ora-24410 : scrollable cursor max size exceeded
  • ora-02474 : Fixed hash area extents used (string) exceeds maximum allowed (string)
  • ora-32163 : Method called on Invalid Environment type
  • ora-31515 : CDC change source string already exists
  • ora-02043 : must end current transaction before executing string
  • ora-16185 : REMOTE_ARCHIVE_ENABLE and LOG_ARCHIVE_CONFIG mutually exclusive
  • ora-00720 : ALTER DATABASE RESET COMPATIBILITY command has been de-supported
  • ora-25231 : cannot dequeue because CONSUMER_NAME not specified
  • ora-01261 : Parameter string destination string cannot be translated
  • ora-29870 : specified options are only valid for altering a domain index
  • ora-34361 : (MXDSS12) number other user reading
  • ora-36206 : (XSAGOP04R) In AGGMAP workspace object, REMOPERATOR string must be MIN, MAX, FIRST, LAST, HFIRST or HLAST.
  • ora-16255 : Log Auto Delete conflicts with another LogMiner session
  • ora-01935 : missing user or role name
  • ora-13236 : internal error in R-tree processing: [string]
  • ora-19026 : EXTRACTVALUE can only retrieve value of leaf node
  • ora-22979 : cannot INSERT object view REF or user-defined REF
  • ora-23312 : not the masterdef according to string
  • ora-16627 : operation disallowed since no standby databases would remain to support protection mode
  • ora-24389 : Invalid scrollable fetch parameters
  • ora-25017 : cannot reference NEW ROWID for movable rows in before triggers
  • ora-02827 : Invalid file number
  • ora-06321 : IPA: Cannot reach the remote side
  • ora-22993 : specified input amount is greater than actual source amount
  • ora-14080 : partition cannot be split along the specified high bound
  • ora-29536 : badly formed source: string
  • ora-08116 : can not acquire dml enough lock(S mode) for online index build
  • ora-31009 : Access denied for property string
  • ora-15057 : specified size of string MB is larger than actual size of string MB
  • ora-00258 : manual archiving in NOARCHIVELOG mode must identify log
  • 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.