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 : 25-04-2017

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

  • ora-13216 : failed to update spatial index
  • ora-12922 : concurrent ALTER DATABASE [NO] FORCE LOGGING command is running
  • ora-02190 : keyword TABLES expected
  • ora-02284 : duplicate INCREMENT BY specifications
  • ora-36610 : (XSLMS00) Unable to locate a message file for OLAP message: value
  • ora-00983 : cannot audit or noaudit SYS user actions
  • ora-39201 : Dump files are not supported for estimate only jobs.
  • ora-01491 : CASCADE option not valid
  • ora-16504 : the Data Guard configuration already exists
  • ora-23393 : the user is already the propagator
  • ora-31151 : Cyclic definition encountered for string: "string"
  • ora-16652 : Fast-Start Failover target standby database is disabled
  • ora-12634 : Memory allocation failed
  • ora-10578 : Can not allow corruption for managed standby database recovery
  • ora-06776 : TLI Driver: error sending parms
  • ora-30686 : no dispatcher accepted TCP/IP connection request
  • ora-01139 : RESETLOGS option only valid after an incomplete database recovery
  • ora-30766 : cannot modify scope for a REF column with a REFERENCES constraint
  • ora-07274 : spdcr: access error, access to oracle denied.
  • ora-02295 : found more than one enable/disable clause for constraint
  • ora-12642 : No session key
  • ora-10579 : Can not modify control file during test recovery
  • ora-23328 : mview base table "string"."string" differs from master table "string"."string"
  • ora-22950 : cannot ORDER objects without MAP or ORDER method
  • ora-31635 : unable to establish job resource synchronization
  • ora-22320 : missing user version string
  • ora-33064 : (XSAGDNGL31) In AGGMAP workspace object, the hierarchy dimension QDR workspace object cannot refer to the related dimension of the relation.
  • ora-38502 : invalid XML tag: string
  • ora-19588 : %s recid string stamp string is no longer valid
  • ora-07845 : sllfcl: LIB$FREE_VM failue
  • 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.