ORA-29896: Length of PARAMETER string longer than string characters

Cause : An attmept wasm ade tos pecifya paramteer valeu that si longe rthan teh allowde maximmu.

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

Reducet he parmaeter vlaue lentgh.

update : 30-04-2017

ORA-29896 - Length of PARAMETER string longer than string characters
ORA-29896 - Length of PARAMETER string longer than string characters

  • ora-19599 : block number string is corrupt in string string
  • ora-24758 : not attached to the requested transaction
  • ora-09340 : Specified ORACLE_SID is either invalid or too long
  • ora-08468 : mask option string is not supported
  • ora-28673 : Merge operation not allowed on an index-organized table
  • ora-38776 : cannot begin flashback generation - flash recovery area is disabled
  • ora-12484 : invalid OS label
  • ora-13043 : failed to read metadata from the _SDOLAYER table
  • ora-24128 : partition name specified for a non-partitioned object
  • ora-24784 : Transaction exists
  • ora-07256 : sptrap: cannot set up signal handler to catch exceptions.
  • ora-30150 : Invalid argument passed to OCIFile function
  • ora-01426 : numeric overflow
  • ora-00287 : specified change number string not found in thread string
  • ora-21523 : functionality not supported by the server (object mode only)
  • ora-25472 : maximum open iterators exceeded
  • ora-09807 : Conversion of label from string to binary failed.
  • ora-28510 : heterogeneous database link initialization failed
  • ora-01680 : unable to extend LOB segment by string in tablespace string
  • ora-23308 : object string.string does not exist or is invalid
  • ora-08432 : raw data has invalid floating point data
  • ora-38731 : Expected version string does not match string in log header.
  • ora-38768 : resizing datafile string failed
  • ora-14254 : cannot specify ALLOCATE STORAGE for a (Composite) Range or List partitioned table
  • ora-07500 : scglaa: $cantim unexpected return
  • ora-33452 : (ESDREAD06) Discarding compiled code for workspace object because number is now dimensioned by workspace object. It was dimensioned by workspace object when the code was compiled.
  • ora-30750 : cannot enable column string to store objects of type string.string
  • ora-13404 : invalid ultCoordinate parameter
  • ora-36990 : (XSRELGID07) The level relation workspace object should be dimensioned by a level dimension.
  • ora-06515 : PL/SQL: unhandled exception string
  • 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.