ORA-16031: parameter string destination string exceeds string character limit

Cause : The value for the specified parameter contained a destination string that is too long.

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

Replace the destination value for the specified parameter with a character string that has a length below the limit specified in the error message.

update : 26-05-2017

ORA-16031 - parameter string destination string exceeds string character limit
ORA-16031 - parameter string destination string exceeds string character limit

  • ora-25212 : invalid PRIORITY specified when using sequence deviation
  • ora-01544 : cannot drop system rollback segment
  • ora-19223 : XP0003 - syntax error in XQuery expression
  • ora-39727 : COMPATIBLE must be set to or higher
  • ora-16726 : the external condition supplied to resource guard is invalid
  • ora-29826 : keyword FOR is missing
  • ora-04093 : references to columns of type LONG are not allowed in triggers
  • ora-31674 : worker process interrupt for unhandled exception in master process
  • ora-07411 : slgfn: full path name too big for supplied buffer.
  • ora-00377 : Frequent backups of file string causing write operation to stall
  • ora-07407 : slbtpd: invalid exponent.
  • ora-14194 : only one subpartition may be rebuilt
  • ora-31516 : CDC change set string already exists
  • ora-06720 : TLI Driver: SID lookup failure
  • ora-33336 : (DSSEXIST04A) Analytic workspace string is not attached.
  • ora-24165 : invalid rule engine object privilege: string
  • ora-07202 : sltln: invalid parameter to sltln.
  • ora-38746 : error occurred while restoring data block (file# string, block# string)
  • ora-37156 : (string)
  • ora-00257 : archiver error. Connect internal only, until freed.
  • ora-29932 : the type being dropped is a statistics type
  • ora-31077 : invalid attribute "string" specified
  • ora-00600 : internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ora-13294 : cannot transform geometry containing circular arcs
  • ora-15176 : file 'string' already has an alias associated with it
  • ora-30337 : multiple JOIN KEY clauses specified for the same parent level
  • ora-19642 : start SCN of incremental backup is string
  • ora-07822 : sspscm: SYS$CREMBX failure
  • ora-25104 : UNRECOVERABLE option can only be used with ALTER INDEX REBUILD
  • ora-06745 : TLI Driver: listener already running
  • 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.