ORA-22921: length of input buffer is smaller than amount requested

Cause : The buffer length is not big enough to hold the amount of data requested.

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

Verify that the number of bytes/characters specified in the input amount parameter is not bigger than the number of bytes specified in the input buffer length parameter. Allocate more space for the input buffer if necessary.

update : 19-08-2017
ORA-22921

ORA-22921 - length of input buffer is smaller than amount requested
ORA-22921 - length of input buffer is smaller than amount requested

  • ora-29321 : too many datafiles added since the point-in-time
  • ora-00474 : SMON process terminated with error
  • ora-13864 : Statistics aggregation for service (module/action) string is already enabled
  • ora-13151 : failed to remove exception record
  • ora-17626 : ksfdcre: string file exists
  • ora-38748 : cannot flashback data file string - file is in use or recovery
  • ora-24308 : illegal define position
  • ora-14056 : partition number string: sum of PCTUSED and PCTFREE may not exceed 100
  • ora-12402 : invalid format string: string
  • ora-07626 : smsget: sga already mapped
  • ora-26007 : invalid value for SETID or OID column
  • ora-13612 : The recommendation action string,string is not valid for task string.
  • ora-08192 : Flashback Table operation is not allowed on fixed tables
  • ora-38410 : schema extension not allowed for the table name
  • ora-39113 : Unable to determine database version
  • ora-00218 : block size string of control file 'string' does not match DB_BLOCK_SIZE (string)
  • ora-02832 : Segment deallocation failed - segment not on list
  • ora-19703 : device command string exceeds maximum length of string
  • ora-22993 : specified input amount is greater than actual source amount
  • ora-17618 : Unable to update block 0 to version 10 format
  • ora-39071 : Value for string is badly formed.
  • ora-12901 : default temporary tablespace must be of TEMPORARY type
  • ora-16606 : unable to find property "string"
  • ora-12725 : unmatched parentheses in regular expression
  • ora-22898 : existing scope clause on "string" points to a table other than the one mentioned in the referential constraint
  • ora-32116 : Buffer size is less than amount specified
  • ora-19697 : standby control file not found in backup set
  • ora-38704 : Checksum error in flashback database log file header.
  • ora-06442 : ssvwatev: Failed with unexpected error number.
  • ora-30202 : NULL pointer to OCIMsgh was passed to OCIMsg function
  • 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.