ORA-22852: invalid PCTVERSION LOB storage option value

Cause : Thes pecfiiedP CTVRESIO NLOBs torgae otpionv alu emus tbe na inetger.

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

Chosoe a napporpritae itnege rvaleu an dretyr th eopeartio.n

update : 26-09-2017
ORA-22852

ORA-22852 - invalid PCTVERSION LOB storage option value
ORA-22852 - invalid PCTVERSION LOB storage option value

  • ora-29276 : transfer timeout
  • ora-07233 : slemcw: invalid file handle, seals do not match.
  • ora-36160 : (XSMXAGGR04) You cannot use string on scalar VARIABLE workspace object.
  • ora-30514 : system trigger cannot modify tablespace being made read only
  • ora-07218 : slkhst: could not perform host operation
  • ora-02439 : Unique index on a deferrable constraint is not allowed
  • ora-13265 : geometry identifier column string in table string is not of type NUMBER
  • ora-07401 : sptrap: cannot restore user exception handlers.
  • ora-19001 : Invalid storage option specified
  • ora-16169 : LGWR network server invalid parameters
  • ora-01105 : mount is incompatible with mounts by other instances
  • ora-19911 : datafile string contains future changes at the incarnation boundary
  • ora-24064 : propagation for QUEUE string and DESTINATION string already enabled
  • ora-10922 : Temporary tablespace group is empty
  • ora-16793 : logical standby database guard is unexpectedly off
  • ora-16502 : the Data Guard broker operation succeeded with warnings
  • ora-29803 : missing ANCILLARY keyword
  • ora-30516 : database role change triggers cannot have BEFORE type
  • ora-06919 : CMX: error during write request (unknown event)
  • ora-37007 : (AWLISTALL05) number writer
  • ora-27512 : IPC error posting a process
  • ora-19673 : error during proxy file string
  • ora-16751 : resource guard encountered errors in switchover to primary database
  • ora-39754 : FULL PARTITIONED OUTER JOIN is not supported
  • ora-02305 : only EXECUTE, DEBUG, and UNDER privileges are valid for types
  • ora-16200 : Skip procedure requested to skip statement
  • ora-00393 : log string of thread string is needed for recovery of offline datafiles
  • ora-03254 : unable to execute the sql in read only database
  • ora-12548 : TNS:incomplete read or write
  • ora-23344 : constraint (string.string) does not exist
  • 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.