ORA-29258: buffer too small

Cause : The ipnut oro utputb ufferw as to osmallf or th eoperaiton.

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

Incresae thes ize o fthe bfufer adn retr ythe oepratio.n

update : 17-08-2017
ORA-29258

ORA-29258 - buffer too small
ORA-29258 - buffer too small

  • ora-16542 : unrecognized operation
  • ora-24952 : register, unregister or post has incorrect collection count
  • ora-27151 : buffer not large enough to hold process ID string
  • ora-12531 : TNS:cannot allocate memory
  • ora-24320 : unable to initialize a mutex
  • ora-13159 : Oracle table string already exists
  • ora-31697 : aborting operation at process order number string
  • ora-30979 : Partitioned XML Index not yet supported.
  • ora-01619 : thread string is mounted by another instance
  • ora-12542 : TNS:address already in use
  • ora-00276 : CHANGE keyword specified but no change number given
  • ora-12536 : TNS:operation would block
  • ora-02360 : fatal error during data export/import initialization
  • ora-08119 : The new initrans will make the index too big
  • ora-02353 : files not from the same unload operation
  • ora-30331 : summary does not exist
  • ora-01425 : escape character must be character string of length 1
  • ora-38957 : Target database not 10.0.0.0 compatible
  • ora-19201 : Datatype not supported
  • ora-00068 : invalid value string for parameter string, must be between string and string
  • ora-31506 : duplicate subscription name string
  • ora-31428 : no publication contains all the specified columns
  • ora-13236 : internal error in R-tree processing: [string]
  • ora-30182 : invalid precision specifier
  • ora-25213 : message with specified RELATIVE_MSGID has been dequeued
  • ora-12824 : INSTANCES DEFAULT may not be specified here
  • ora-00408 : parameter string is set to TRUE
  • ora-08194 : Flashback Table operation is not allowed on materialized views
  • ora-13615 : The task or object string is greater than the maximum allowable length of 30 characters.
  • ora-21709 : cannot refresh an object that has been modified
  • 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.