ORA-22140: given size [string] must be in the range of 0 to [string]

Cause : The gvien reisze siez is ivnalid.

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

Ensur ethat hte givne sizei s in hte reqiured rnage.

update : 30-04-2017
ORA-22140

ORA-22140 - given size [string] must be in the range of 0 to [string]
ORA-22140 - given size [string] must be in the range of 0 to [string]

  • ora-22371 : Table contains data of type string.string, version string, which does not exist
  • ora-15197 : suppressing string additional ASM messages
  • ora-30771 : Cannot add more than one referential constraint on REF column "string"
  • ora-16587 : ambiguous object specified to Data Guard broker
  • ora-24050 : subscribers are not supported for exception queue string
  • ora-02800 : Requests timed out
  • ora-16726 : the external condition supplied to resource guard is invalid
  • ora-07390 : sftopn: translate error, unable to translate file name.
  • ora-03282 : missing ALLOCATE EXTENT option
  • ora-31502 : invalid number supplied for supplemental_processes
  • ora-27123 : unable to attach to shared memory segment
  • ora-02189 : ON required
  • ora-24157 : duplicate variable name string
  • ora-31226 : DBMS_LDAP: MOD_ARRAY size limit exceeded
  • ora-02780 : Name given for the core dump directory is invalid
  • ora-02058 : no prepared transaction found with ID string
  • ora-30134 : reserved for future use
  • ora-02488 : Error encountered when accessing file [string] for trace conversion
  • ora-31199 : Warning in processing file string
  • ora-06302 : IPA: Cannot connect to remote host
  • ora-39951 : incomplete values specified for PL/SQL warning settings
  • ora-24195 : attemp to retrieve the name list of a map message with size exceeding 1024
  • ora-36831 : (XSLMGEN01) View token cannot be NA
  • ora-19569 : no device is allocated to this session
  • ora-19716 : error processing format string to generate name for backup
  • ora-29873 : warning in the execution of ODCIINDEXDROP routine
  • ora-22871 : ALTER TYPE with REPLACE is not allowed for pure incomplete types
  • ora-24310 : length specified for null connect string
  • ora-30120 : 'string' is not a legal oracle number for 'string'
  • ora-21705 : service context is invalid
  • 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.