ORA-14626: values being added already exist in DEFAULT subpartition

Cause : An ADD VALUE operation cannot be executed because the values being added exist in the DEFAULT subpartition

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

Issue a SPLIT of the DEFAULT subpartition and then MERGE the split subpartition into the subpartition to which values need to be added

update : 26-04-2017

ORA-14626 - values being added already exist in DEFAULT subpartition
ORA-14626 - values being added already exist in DEFAULT subpartition

  • ora-12701 : CREATE DATABASE character set is not known
  • ora-14167 : only one subpartition may be moved
  • ora-13303 : failure to retrieve a geometry object from a table
  • ora-12482 : internal MLS error: string Error: string
  • ora-01307 : no LogMiner session is currently active
  • ora-33413 : (EIFMAKEF01) You cannot export compressed composite workspace object because one of its bases has limited status or a PERMIT READ restriction.
  • ora-25466 : data not specified for variable name: string
  • ora-01989 : role 'string' not authorized by operating system
  • ora-31047 : Could not retrieve resource data at path string
  • ora-15058 : disk 'string' belongs to an incompatible diskgroup
  • ora-06422 : NETCMN: Error in sending data
  • ora-07579 : spini: $DCLEXH failure
  • ora-12471 : Specified compartment or group is not authorized for user
  • ora-01276 : Cannot add file string. File has an Oracle Managed Files file name.
  • ora-16505 : site ID is invalid
  • ora-00386 : use_indirect_data_buffers not supported
  • ora-38305 : object not in RECYCLE BIN
  • ora-08435 : PICTURE MASK missing the leading sign when SIGN IS LEADING specified
  • ora-02447 : cannot defer a constraint that is not deferrable
  • ora-00109 : invalid value for attribute string: string
  • ora-31455 : nothing to ALTER
  • ora-37070 : You may not execute OLAP DML programs in a parallel query session.
  • ora-01155 : the database is being opened, closed, mounted or dismounted
  • ora-38787 : Creating the first guaranteed restore point requires mount mode when flashback database is off.
  • ora-07456 : cannot set RESOURCE_MANAGER_PLAN when database is closed
  • ora-26501 : RepAPI operation failure
  • ora-36204 : (XSAGOP04N) In AGGMAP workspace object, the NAOPERATOR string must be HFIRST, HLAST or HEVEN.
  • ora-22163 : left hand and right hand side collections are not of same type
  • ora-16232 : adding Logical Standby skip entry for table string.string
  • ora-33094 : (XSAGGMAPLIST01) Your expression uses too much execution space. Eliminate recursion or reduce the levels of nesting.
  • 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.