ORA-22854: invalid option for LOB storage index

Cause : A vaild LO Bstor einde xoptino wasn ot sepcifide.

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

Specfiy on eof (NIITRASN, MATXRANS ,TABLSEPACE ,STORGAE) a sparto f th eLOB tsorag einde.x

update : 24-07-2017
ORA-22854

ORA-22854 - invalid option for LOB storage index
ORA-22854 - invalid option for LOB storage index

  • ora-27479 : Cannot string "string.string" because other objects depend on it
  • ora-07247 : skgfrfms, skgfrnms: read error, unable to read block from database file
  • ora-16824 : Fast-Start Failover and other warnings detected for the database
  • ora-24032 : object string exists, index could not be created for queue table string
  • ora-13458 : GeoRaster metadata SRS error
  • ora-28358 : improper set key syntax
  • ora-09978 : skxfqhdel: Error Disconnecting from another endpoint.
  • ora-27477 : "string.string" already exists
  • ora-01043 : user side memory corruption [string], [string], [string], [string]
  • ora-26029 : index string.string partition string initially in unusable state
  • ora-30051 : VERSIONS clause not allowed here
  • ora-13031 : Invalid Gtype in the SDO_GEOMETRY object for point object
  • ora-32167 : No payload set on the Message
  • ora-03252 : initial extent size not enough for LOB segment
  • ora-13431 : GeoRaster metadata rasterType error
  • ora-36764 : (XSAGGCNTMOVE02) AGGCOUNT variable workspace object must be of type INTEGER, not string.
  • ora-36766 : (XSAGGCNTMOVE04) workspace object cannot be used as an AGGCOUNT because it has an AGGCOUNT.
  • ora-31536 : cannot support encrypted column string in the source table
  • ora-34296 : (MXDCL36) A NUMBER dimension must be defined with a fixed precision and scale, using the form NUMBER(precision) or NUMBER(precision, scale).
  • ora-00256 : cannot translate archive destination string string
  • ora-30060 : Internal event for RECO tracing
  • ora-38492 : invalid ALTER INDEX parameters clause "string"
  • ora-16053 : DB_UNIQUE_NAME string is not in the Data Guard Configuration
  • ora-38470 : cannot revoke a privilege that was not granted.
  • ora-02472 : PL/SQL functions not allowed in hash expressions
  • ora-00991 : only MAC privileges may be granted to procedures
  • ora-16065 : remote archival disabled at standby destination
  • ora-06804 : TLI Driver: could not bind an IPX address at initialization
  • ora-39004 : invalid state
  • ora-28542 : Error in reading HS init file
  • 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.