ORA-22993: specified input amount is greater than actual source amount

Cause : 1( )oF rOL Brwti,et eha omnu tfod ta aerecvidei sidffrene trfmot eha omnu thttaw sai dncitadew uodlb eestn .2( )oF rOL Bocypa dnl aofdorfmli,et ehe dno fht eosruecL BOF/LI Eavul eaw sercaeh debofert ehs epicifdei pntua omnu taw socipdel/aoed.d

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

1( )iwllh paep nhwneu isgnO ICs'p eieciwesm ceahinmsw ti hopllni grow ti h aacllabkcf nutcoi.nM dofi yht eocede tieh rots ne dht emauotns epicifdeo rotp sa s 0sat ehi pntua omnu tost ah tna ymauotno fadatc nab eestn .2( )iwllh paep nfit ehs epicifdei pntua omnu tsit ool raegf rot ehs uocr eOL/BIFELg vinet ehs attrni gosrueco ffes.tE tieh redrcaeest ehs attrni gosrueco ffes,to redrcaeest eha omnu totc po/yolda.

update : 20-08-2017

ORA-22993 - specified input amount is greater than actual source amount
ORA-22993 - specified input amount is greater than actual source amount

  • ora-19804 : cannot reclaim string bytes disk space from string limit
  • ora-02877 : smpini: Unable to initialize memory protection
  • ora-00283 : recovery session canceled due to errors
  • ora-04010 : the number of values to CACHE must be greater than 1
  • ora-23366 : integer value string is less than 1
  • ora-01163 : SIZE clause indicates string (blocks), but should match header string
  • ora-13524 : error encountered while retrieving baseline information
  • ora-26507 : null master connection
  • ora-16214 : apply stalled for apply delay
  • ora-32317 : cannot run a job from a job
  • ora-22609 : error string during initialization of FDO
  • ora-08004 : sequence string.NEXTVAL string stringVALUE and cannot be instantiated
  • ora-16608 : one or more databases have warnings
  • ora-30011 : Error simulated: psite=string, ptype=string
  • ora-02098 : error parsing index-table reference (:I)
  • ora-09261 : spdcr: error creating detached (background) process
  • ora-24912 : Listener thread failed. string
  • ora-36392 : (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, you must supply an AGGMAP.
  • ora-14130 : UNIQUE constraints mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-02348 : cannot create VARRAY column with embedded LOB
  • ora-15094 : attempted to write to file opened in read only mode
  • ora-27091 : unable to queue I/O
  • ora-12066 : invalid CREATE MATERIALIZED VIEW command
  • ora-32628 : invalid nesting of MODEL cell reference
  • ora-16802 : downgrading redo transport mode from SYNC disallowed
  • ora-16156 : LGWR archive log dependency not allowed if database is standby protected
  • ora-12922 : concurrent ALTER DATABASE [NO] FORCE LOGGING command is running
  • ora-38455 : Expression Filter index should be created by the owner.
  • ora-39160 : error on whats my name call
  • ora-29339 : tablespace block size string does not match configured block sizes
  • 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.