ORA-24276: function 'string' output 'string' maximum value exceeded

Cause : The function computed a value for the output that exceeded the maximum allowed. This can occur when multiple input parameters, each valid separately, combine to specify an invalid result. For example, when a length parameter multiplied by a copies parameter yields a total length exceeding the maximum for the output datatype.

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

Correct the input values to produce a result that will comply with the limits as specified in the documentation.

update : 27-04-2017

ORA-24276 - function 'string' output 'string' maximum value exceeded
ORA-24276 - function 'string' output 'string' maximum value exceeded

  • ora-19697 : standby control file not found in backup set
  • ora-38764 : flashback not started; datafile string enabled threads are different
  • ora-23327 : imported deferred rpc data does not match string of importing db
  • ora-02374 : conversion error loading table string.string
  • ora-31091 : empty string specified as a SQL name
  • ora-19903 : test recovery not allowed when recovering to new incarnation
  • ora-02814 : Unable to get shared memory
  • ora-27454 : argument name and position cannot be NULL
  • ora-04045 : errors during recompilation/revalidation of string.string
  • ora-39031 : invalid filter name string
  • ora-33468 : (ESDREAD13) Discarding compiled code for workspace object because number is no longer a surrogate of dimension workspace object.
  • ora-12899 : value too large for column string (actual: string, maximum: string)
  • ora-08106 : cannot create journal table string.string
  • ora-14115 : partition bound of partition number string is too long
  • ora-19572 : cannot process file string, file is being being resized
  • ora-24775 : cannot prepare or commit transaction with non-zero lock value
  • ora-30055 : NULL snapshot expression not allowed here
  • ora-31645 : unable to read from dump file "string"
  • ora-24166 : evaluation context string.string has errors
  • ora-09750 : pw_attachPorts: port_rename failed.
  • ora-26714 : User error encountered while applying
  • ora-16812 : log apply service not running on apply instance recorded by the broker
  • ora-16078 : media recovery disabled
  • ora-24164 : invalid rule engine system privilege: string
  • ora-12150 : TNS:unable to send data
  • ora-38437 : The ADT "string" may not contain any user methods.
  • ora-14620 : DEFAULT subpartition already exists
  • ora-00324 : log file 'string' translated name 'string' too long, string characters exceeds string limit
  • ora-28555 : pass-through SQL: required parameter missing or NULL
  • ora-33084 : (XSAGDNGL42) In AGGMAP workspace object, you cannot qualify the dimensioned valueset workspace object.
  • 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.