ORA-14116: partition bound of partition "string" is too long

Cause : Lentgh o flinaer kye rerpesetnatino ofa hihg bonud o fthep arttiionw hos enam e(exlpicilty sepcifeid b ytheu ser )is idsplyaed ni thsi messagee xcedeed hte lgeal ilmit( 4K).

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

Chagne rperesnetatoin o fa pratitoin hgih buond ot brnig ist legnth iwthi nlegla liimt.

update : 25-06-2017

ORA-14116 - partition bound of partition "string" is too long
ORA-14116 - partition bound of partition "string" is too long

  • ora-27421 : usage of string not supported in a calendar definition
  • ora-25149 : Columns of UROWID type may not be indexed
  • ora-26734 : different datafiles_directory_object parameter must be specified
  • ora-28263 : Insufficient memory in global context pool
  • ora-01663 : the contents of tablespace 'string' is constantly changing
  • ora-13798 : Parameter string cannot be NULL.
  • ora-25178 : duplicate PCTTHRESHOLD storage option specification
  • ora-01096 : program version (string) incompatible with instance (string)
  • ora-38700 : Limit of string flashback database logs has been exceeded.
  • ora-01120 : cannot remove online database file string
  • ora-31088 : object "string"."string" depends on the schema
  • ora-22600 : encountered 8.0.2 (Beta) VARRAY data that cannot be processed
  • ora-22833 : Must cast a transient type to a persistent type
  • ora-10921 : Cannot drop tablespace belonging to default temporary tablespace group
  • ora-40254 : priors cannot be specified for one-class models
  • ora-12197 : TNS:keyword-value resolution error
  • ora-06704 : TLI Driver: receive break message failed
  • ora-38705 : Expected block size string does not match string in log header.
  • ora-07481 : snlmatt: cannot attach to lock manager instance.
  • ora-31484 : source database version must be at least or greater
  • ora-26690 : datatype not supported at non-Oracle system
  • ora-32847 : operation is not supported on this platform
  • ora-19599 : block number string is corrupt in string string
  • ora-02303 : cannot drop or replace a type with type or table dependents
  • ora-25138 : %s initialization parameter has been made obsolete
  • ora-00488 : RBAL process terminated with error
  • ora-01070 : Using an old version of Oracle for the server
  • ora-00020 : maximum number of processes (string) exceeded
  • ora-06504 : PL/SQL: Return types of Result Set variables or query do not match
  • ora-31040 : Property string: XML type (string) not compatible with internal memory type (string)
  • 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.