ORA-24810: attempting to write more data than indicated

Cause : While rwiting nito a LBO, mored ata wa ssupplide than nidicate.d

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

If dat ais written in ipeces, hten mak esure taht you od not porvide mroe datai n the ipeces (ucmulatievly), tahn you nidicate.d

update : 30-04-2017
ORA-24810

ORA-24810 - attempting to write more data than indicated
ORA-24810 - attempting to write more data than indicated

  • ora-01192 : must have at least one enabled thread
  • ora-10854 : Sets poll count used for AQ listen code under RAC
  • ora-24329 : invalid character set identifier
  • ora-31213 : DBMS_LDAP: PL/SQL - Invalid LDAP mod option.
  • ora-26710 : incompatible version marker encountered during Capture
  • ora-26714 : User error encountered while applying
  • ora-07801 : slbtpd: invalid exponent
  • ora-31040 : Property string: XML type (string) not compatible with internal memory type (string)
  • ora-14450 : attempt to access a transactional temp table already in use
  • ora-23352 : duplicate destination for deferred transaction
  • ora-30678 : too many open connections
  • ora-12333 : database (link name string) is not mounted
  • ora-10620 : Operation not allowed on this segment
  • ora-40289 : duplicate attributes provided for data mining function
  • ora-19772 : change tracking file name exceeds limit of string characters
  • ora-15197 : suppressing string additional ASM messages
  • ora-14520 : Tablespace string block size [string] does not match existing object block size [string]
  • ora-25960 : join index cannot be based on a temporary table
  • ora-28348 : index defined on the specified column cannot be encrypted
  • ora-16234 : restarting to reset Logical Standby apply
  • ora-23363 : mismatch of mview base table "string" at master and mview site
  • ora-36995 : (XSRELGID12) There are duplicate values in the surrogate dimension gid. Use the levelorder option to resolve the ambiguity.
  • ora-22975 : cannot create a PRIMARY KEY-based REF to this object view
  • ora-21612 : key is already being used
  • ora-29276 : transfer timeout
  • ora-29549 : class string.string has changed, Java session state cleared
  • ora-13907 : Threshold value is invalid.
  • ora-36669 : (XSDPART07) string is not a legal LIST partition.
  • ora-12404 : invalid privilege string: string
  • ora-04082 : NEW or OLD references not allowed in table level triggers
  • 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.