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 : 24-05-2017
ORA-22996

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

  • ora-27021 : sequential file handle must be specified
  • ora-02464 : Cluster definition can not be both HASH and INDEX
  • ora-22604 : TDS handle already generated
  • ora-13269 : internal error [string] encountered when processing geometry table
  • ora-25463 : table alias not specified
  • ora-31442 : operation timed out while acquiring lock on string
  • ora-29900 : operator binding does not exist
  • ora-09859 : sfngat: the input file name is not in the autobackup OMF format
  • ora-36667 : (XSDPART05) string is not a legal CONCAT partition.
  • ora-08190 : restore point string is from a different incarnation of the database
  • ora-13147 : failed to generate MBR
  • ora-27479 : Cannot string "string.string" because other objects depend on it
  • ora-36665 : (XSDPART03) workspace object is not in the dimension list of the PARTITION TEMPLATE.
  • ora-16046 : Archive log destination failed due to failed dependent destination
  • ora-14041 : partition bound may not be specified for resulting partitions
  • ora-07606 : szprv: $CHKPRO failure
  • ora-12516 : TNS:listener could not find available handler with matching protocol stack
  • ora-16738 : redo tranport service for standby database "string" unexpectedly offline
  • ora-26693 : STREAMS string process dropped successfully, but error occurred while dropping rule set string
  • ora-16057 : DGID from server not in Data Guard configuration
  • ora-25225 : invalid value string, DEQUEUE_MODE should be REMOVE or BROWSE or LOCKED
  • ora-07244 : ssfccf: create file failed, file size limit reached.
  • ora-23514 : invalid or incorrect number of arguments
  • ora-25216 : invalid recipient, either NAME or ADDRESS must be specified
  • ora-00912 : input parameter too long
  • ora-39022 : Database version string is not supported.
  • ora-25454 : error during evaluation of rule set: string.string for iterator: string
  • ora-09793 : szguns: length of user name is greater than buffer.
  • ora-02484 : Invalid _trace_buffers parameter specification (string)
  • ora-01942 : IDENTIFIED BY and EXTERNALLY cannot both be specified
  • 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.