ORA-22130: buffer size [string] is less than the required size [string]

Cause : The size of the buffer into which the hexadecimal REF string is to be written is too small.

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

Provide a buffer of the required size.

update : 30-05-2017
ORA-22130

ORA-22130 - buffer size [string] is less than the required size [string]
ORA-22130 - buffer size [string] is less than the required size [string]

  • ora-10562 : Error occurred while applying redo to data block (file# string, block# string)
  • ora-38414 : invalid datatype for the attribute string
  • ora-09843 : soacon: Archmon unable to create named pipe.
  • ora-02472 : PL/SQL functions not allowed in hash expressions
  • ora-12198 : TNS:could not find path to destination
  • ora-01942 : IDENTIFIED BY and EXTERNALLY cannot both be specified
  • ora-08401 : invalid compiler name: string
  • ora-22053 : overflow error
  • ora-12454 : label string does not exist for policy string
  • ora-30349 : specified dimension hierarchy does not exist
  • ora-29934 : index specified for association is not a domain index
  • ora-14457 : disallowed Nested Table column in a Temporary table
  • ora-13757 : "SQL Tuning Set" "string" owned by user "string" is active.
  • ora-16009 : remote archive log destination must be a STANDBY database
  • ora-29805 : missing COLUMN keyword
  • ora-02265 : cannot derive the datatype of the referencing column
  • ora-19674 : file string is already being backed up with proxy copy
  • ora-10620 : Operation not allowed on this segment
  • ora-32593 : database supplemental logging attributes in flux
  • ora-36922 : (XSVPMVTOPART03) workspace object is the target of an external partition of a partitioned variable.
  • ora-01953 : command no longer valid, see ALTER USER
  • ora-29547 : Java system class not available: string
  • ora-23373 : object group "string"."string" does not exist
  • ora-23385 : replication parallel push string argument not valid
  • ora-34871 : (PERMIT06) Session-only value 'value' of workspace object has been deleted because a PERMIT change has revealed a duplicate value.
  • ora-29294 : A data error occurred during compression or uncompression.
  • ora-12538 : TNS:no such protocol adapter
  • ora-00362 : member is required to form a valid logfile in group string
  • ora-38504 : this operator not allowed with the configured attribute set
  • ora-09745 : smscre: vm_allocate error, unable to create shared memory.
  • 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.