ORA-14628: specification of bounds is inconsistent with LIST method

Cause : An operation such as ALTER TABLE SPLIT|ADD SUBPARTITION specified bounds that were inconsistent with List subpartitioning method

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

Specify VALUES/subpartition descriptions correctly for SPLIT/ADD of List subpartitions

update : 25-05-2017

ORA-14628 - specification of bounds is inconsistent with LIST method
ORA-14628 - specification of bounds is inconsistent with LIST method

  • ora-00129 : listener address validation failed 'string'
  • ora-30397 : multiple JOIN KEY clauses specified for the same child level
  • ora-31462 : internal error while accessing metadata
  • ora-37602 : (XSPGERRTEMPUSER) Ran out of temporary storage while writing to analytic workspace string. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-19768 : USING clause only valid with ENABLE CHANGE TRACKING
  • ora-15095 : reached maximum ASM file size (string GB)
  • ora-30772 : opaque types do not have default constructors
  • ora-14620 : DEFAULT subpartition already exists
  • ora-22627 : tc [string] must be that of object/varray/nested table
  • ora-31650 : timeout waiting for master process response
  • ora-16559 : out of memory at string
  • ora-39125 : Worker unexpected fatal error in string while calling string [string]
  • ora-01088 : cannot shut down ORACLE while active processes exist
  • ora-12422 : max policies exceeded
  • ora-19015 : Invalid XML tag identifier (string)
  • ora-31226 : DBMS_LDAP: MOD_ARRAY size limit exceeded
  • ora-01597 : cannot alter system rollback segment online or offline
  • ora-36835 : (XSLMGEN05) Dimension string.string!string hierarchy string level string is missing a COLUMNNAME property value
  • ora-28526 : invalid describe information returned to Heterogeneous Services
  • ora-12079 : materialized view options require COMPATIBLE parameter to be string or greater
  • ora-01594 : attempt to wrap into rollback segment (string) extent (string) which is being freed
  • ora-12196 : TNS:received an error from TNS
  • ora-16798 : unable to complete terminal recovery on the standby database
  • ora-36765 : (XSAGGCNTMOVE03) A string aggregation variable cannot have a string AGGCOUNT.
  • ora-09366 : Windows 3.1 Two-Task driver unable to allocate shared memory
  • ora-00444 : background process "string" failed while starting
  • ora-23332 : group string is in use; cannot drop
  • ora-12316 : syntax error in database link's connect string
  • ora-30434 : refresh method must be one of FC?AN, not 'string'
  • ora-00306 : limit of string instances in this database
  • 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.