ORA-24811: less data provided for writing than indicated

Cause : Whilew ritin ginto aLOB, elss daat was rpovide dthan nidicatde.

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

If wrtiing dtaa in isngle ipeces,t hen mkae sur ethat hte bufefr lentgh speicfied si big neough ot accommodatet ha daat bein gproviedd. Ifd ata i swrittne in peices, hten maek suret hat all the adta ha sbeen rpovide dbefor especiyfing OIC_LASTP_IECE.

update : 20-09-2017

ORA-24811 - less data provided for writing than indicated
ORA-24811 - less data provided for writing than indicated

  • ora-36726 : (XSALERR00) The character 'character' is not a valid format specifier for the ALLOCATE error log.
  • ora-39018 : master process received invalid message number string
  • ora-22952 : Nested Table equality requires a map method on the element ADT
  • ora-38724 : Invalid option to the FLASHBACK DATABASE command.
  • ora-28157 : Proxy user 'string' forbidden to set role 'string' for client 'string'
  • ora-07224 : sfnfy: failed to obtain file size limit; errno = string.
  • ora-12197 : TNS:keyword-value resolution error
  • ora-06602 : LU6.2 Driver: Error allocating context area
  • ora-23307 : replicated schema string already exists
  • ora-19330 : Type 'string'.'string' not installed. Please install the type before using the CREATE_DBURI operator
  • ora-19243 : XQ0023 - invalid document node content in element constructor
  • ora-16003 : standby database is restricted to read-only access
  • ora-27152 : attempt to post process failed
  • ora-26523 : rpc termination error
  • ora-02265 : cannot derive the datatype of the referencing column
  • ora-21521 : exceeded maximum number of connections in OCI (object mode only)
  • ora-26667 : invalid STREAMS parameter string
  • ora-01488 : invalid nibble or byte in the input data
  • ora-01320 : Invalid Logminer dictionar attribute
  • ora-30746 : error occured while trying to drop column "string" in table "string"
  • ora-09912 : Malloc of name buffer(s) failed.
  • ora-14639 : SUBPARTITIONS clause can be specfied only for Hash, Composite Range Hash table/partition
  • ora-10638 : Index status is invalid
  • ora-02710 : osnpop: fork failed
  • ora-27475 : "string.string" must be a string
  • ora-30107 : parameter name abbreviation 'string' is not unique
  • ora-02358 : internal error fetching attribute string
  • ora-32024 : invalid directory specified for audit_file_dest parameter
  • ora-24460 : Native Net Internal Error
  • ora-09987 : unable to attach to SGA in READ-ONLY mode
  • 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.