ORA-22996: NEXT extent size is smaller than LOB chunksize

Cause : An tatemtp wa smad eto rceat eor latera LO Bsegemnt os thta it sNEX Textnet szie wsa less thna th eLOBc hunskize

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

Speicfy aNEX Textnet szie taht i sgretaer htan ro eqaul t otheL OB hcunkisze

update : 29-06-2017
ORA-22996

ORA-22996 - NEXT extent size is smaller than LOB chunksize
ORA-22996 - NEXT extent size is smaller than LOB chunksize

  • ora-30569 : data type of given column is not supported in a log group
  • ora-13951 : MMON sub-action time limit exceeded
  • ora-13428 : invalid modelCoordinateLocation
  • ora-27458 : A program of type PLSQL_BLOCK cannot have any arguments.
  • ora-00821 : Specified value of sga_target stringM is too small, needs to be at least stringM
  • ora-29803 : missing ANCILLARY keyword
  • ora-29502 : NAMED keyword required in CREATE JAVA RESOURCE
  • ora-29975 : Cannot register a query in the middle of an active transaction
  • ora-29810 : inadequate operator privileges
  • ora-06779 : TLI Driver: error reading ccode
  • ora-29954 : domain index partition is marked LOADING/FAILED/UNUSABLE
  • ora-21700 : object does not exist or is marked for delete
  • ora-29298 : Character set mismatch
  • ora-12916 : Cannot use default permanent tablespace with this release
  • ora-22952 : Nested Table equality requires a map method on the element ADT
  • ora-13375 : the layer is of type [string] while geometry inserted has type [string]
  • ora-14455 : attempt to create referential integrity constraint on temporary table
  • ora-29542 : class string already defined by source string
  • ora-37172 : illegal dimension type
  • ora-02094 : replication option not installed
  • ora-19227 : XP0007 - fn:data function is applied to a node (type (string)) whose type annotation denotes a complex type with non-mixed complex content.
  • ora-13612 : The recommendation action string,string is not valid for task string.
  • ora-08274 : Out of memory for environment variable
  • ora-13342 : an arc geometry has fewer than three coordinates
  • ora-15157 : rolling upgrade or downgrade is not allowed
  • ora-13506 : operation failed due to invalid snapshot range (string, string)
  • ora-01424 : missing or illegal character following the escape character
  • ora-38781 : cannot disable media recovery - have guaranteed restore points
  • ora-06748 : TLI Driver: cannot allocate t_discon
  • ora-16733 : error executing dbms_logstdby.unskip procedure
  • 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.