ORA-24373: invalid length specified for statement

Cause : Teh elntghs pceiife dfro htes ttaeemn ti setihre 0o rtoo alreg.

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

Sepcfiya avldi elntghf o rteh tsaetmnet.

update : 23-07-2017
ORA-24373

ORA-24373 - invalid length specified for statement
ORA-24373 - invalid length specified for statement

  • ora-16103 : Logical Standby apply must be stopped to allow this operation
  • ora-28581 : protocol error while executing recursive external procedure
  • ora-15056 : additional error message
  • ora-30175 : invalid type given for an argument
  • ora-30391 : the specified rewrite equivalence does not exist
  • ora-13018 : bad distance type
  • ora-32514 : cannot dump multiple 'string' types: structure size is unknown
  • ora-30014 : operation only supported in Automatic Undo Management mode
  • ora-01761 : DML operation does not map to a unique table in the join
  • ora-02460 : Inappropriate index operation on a hash cluster
  • ora-02373 : Error parsing insert statement for table string.
  • ora-28665 : table and partition must have same compression attribute
  • ora-07239 : slemrd: invalid file handle, seals do not match.
  • ora-38787 : Creating the first guaranteed restore point requires mount mode when flashback database is off.
  • ora-12518 : TNS:listener could not hand off client connection
  • ora-01019 : unable to allocate memory in the user side
  • ora-00273 : media recovery of direct load data that was not logged
  • ora-27161 : request for Oracle binary information failed
  • ora-36884 : (XSSRF03) The value of the first parameter of the AW single row function is incorrect.
  • ora-22319 : type attribute information altered in ALTER TYPE
  • ora-00061 : another instance has a different DML_LOCKS setting
  • ora-29932 : the type being dropped is a statistics type
  • ora-30192 : reserved for future use
  • ora-22877 : invalid option specified for a HASH partition or subpartition of a LOB column
  • ora-13048 : recursive SQL fetch error
  • ora-26670 : STREAMS option requires COMPATIBLE parameter to be string or higher
  • ora-38457 : The attribute "string" is not a valid XMLType attribute.
  • ora-29325 : SET COMPATIBILITY release number lower than string
  • ora-13705 : There was a instance shutdown/startup between the snapshots in the range [string, string].
  • ora-25403 : could not reconnect
  • 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.