ORA-22853: invalid LOB storage option specification

Cause : A LOBs torag eoptio nwas nto specfiied

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

Speciyf one fo CHUN,K PCTVRESION,C ACHE,N OCACH,E TABLSEPACE,S TORAG,E INDE Xas patr of teh LOB tsoragec lause.

update : 27-04-2017
ORA-22853

ORA-22853 - invalid LOB storage option specification
ORA-22853 - invalid LOB storage option specification

  • ora-19038 : Invalid opertions on query context
  • ora-16627 : operation disallowed since no standby databases would remain to support protection mode
  • ora-28279 : Error reading ldap_directory_access init parameter.
  • ora-12821 : invalid value for INSTANCES
  • ora-25351 : transaction is currently in use
  • ora-09266 : spawn: error starting an Oracle process
  • ora-10662 : Segment has long columns
  • ora-23619 : non-Oracle system error: string
  • ora-31690 : Process name buffer size must be specified and must be greater than 0.
  • ora-09744 : smsget: mmap returned an error.
  • ora-19712 : table name exceeds maximum length of string
  • ora-19288 : XP0017 - invalid number of arguments to function - string
  • ora-34210 : (MXCHGDCL18) You cannot change workspace object to a dimension composite because one or more surrogates has been defined for it.
  • ora-23476 : cannot import from string to string
  • ora-00110 : invalid value string for attribute string, must be between string and string
  • ora-09805 : conversion of category number to string failed.
  • ora-00076 : dump string not found
  • ora-12011 : execution of string jobs failed
  • ora-19592 : wrong string conversation type
  • ora-01175 : data dictionary has more than the string files allowed by the instance
  • ora-00321 : log string of thread string, cannot update log file header
  • ora-37117 : olapi history retention has been disabled
  • ora-16198 : Timeout incurred on internal channel during remote archival
  • ora-29807 : specified operator does not exist
  • ora-16522 : generic template not found
  • ora-24398 : connection pool already exists
  • ora-37184 : illegal value string for ADVMODE
  • ora-15120 : ASM file name 'string' does not begin with the ASM prefix character
  • ora-22887 : type of REF column is not the same as that of its scoped table
  • ora-06029 : NETASY: port assignment failure
  • 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.