ORA-14314: resulting List partition(s) must contain atleast 1 value

Cause : After a SPLIT/DROP VALUE of a list partition, each resulting partition(as applicable) must contain at least 1 value

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

Ensure that each of the resulting partitions contains atleast 1 value

update : 26-06-2017

ORA-14314 - resulting List partition(s) must contain atleast 1 value
ORA-14314 - resulting List partition(s) must contain atleast 1 value

  • ora-02817 : Read failed
  • ora-24392 : no connection pool to associate server handle
  • ora-00018 : maximum number of sessions exceeded
  • ora-06527 : External procedure SQLLIB error: string
  • ora-12416 : policy string not found
  • ora-14183 : TABLESPACE DEFAULT can be specified only for Composite LOCAL index
  • ora-16534 : no more requests accepted
  • ora-19813 : cannot have unavailable file string in DB_RECOVERY_FILE_DEST
  • ora-00077 : dump string is not valid
  • ora-36268 : (XSCGMDLAGG01) 'string' is not a valid dimension value.
  • ora-38602 : FI invalid input cursor
  • ora-25220 : enqueue failed, signature not specified for a non-repudiable queue
  • ora-13304 : failure to insert a transformed geometry object in a table
  • ora-13039 : failed to update spatial index for element string.string.string
  • ora-22860 : object type expected
  • ora-29387 : no top-plans found in the pending area
  • ora-31102 : Already locked in exclusive mode. Cannot add lock.
  • ora-25123 : Too many components specified in the name.
  • ora-13430 : the GeoRaster object has null attribute(s)
  • ora-14125 : REVERSE/NOREVERSE may not be specified in this context
  • ora-37103 : (XSVPART03) The dimensionality or datatype of workspace object does not match the dimensionality or datatype of the partition.
  • ora-40219 : apply result table string is incompatible with current operation
  • ora-29337 : tablespace 'string' has a non-standard block size (string)
  • ora-31517 : CDC change table string.string already exists
  • ora-06921 : CMX: getdatmsg illegal datatype
  • ora-02484 : Invalid _trace_buffers parameter specification (string)
  • ora-00023 : session references process private memory; cannot detach session
  • ora-02764 : Invalid package mode
  • ora-14262 : new subpartition name must differ from the old subpartition name
  • ora-23487 : object groups "string"."string" and "string"."string" do not have the same connection qualifier
  • 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.