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 : 23-07-2017

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

  • ora-06031 : NETDNT: connect failed, unrecognized object name
  • ora-25506 : resource manager has not been continuously on in some instances
  • ora-16139 : media recovery required
  • ora-02339 : invalid column specification
  • ora-14064 : Index with Unusable partition exists on unique/primary constraint key
  • ora-10627 : Dump the content of the index leaf block
  • ora-04088 : error during execution of trigger 'string.string'
  • ora-02232 : invalid MOUNT mode
  • ora-06006 : NETASY: dialogue execute failure
  • ora-25018 : conflicting trigger string already exists
  • ora-01296 : character set mismatch between dictionary string and logfiles
  • ora-01240 : too many data files to add in one command
  • ora-01106 : database must be closed before dismounting
  • ora-06755 : TLI Driver: cannot close transport endpoint
  • ora-07303 : ksmcsg: illegal database buffer size.
  • ora-10573 : Test recovery tested redo from change string to string
  • ora-24501 : invalid UTF16 string passed in
  • ora-08452 : specification of E in picture mask is unsupported
  • ora-06973 : X.25 Driver: invalid buffer size
  • ora-21522 : attempted to use an invalid connection in OCI (object mode only)
  • ora-00072 : process "string" is not active
  • ora-39106 : Worker process string failed during startup. Worker error:
  • ora-24363 : measurements in characters illegal here
  • ora-01757 : Must specify an object number
  • ora-28275 : Multiple mappings for user nickname to LDAP distinguished name exist.
  • ora-37602 : (XSPGERRTEMPUSER) Ran out of temporary storage while writing to analytic workspace string. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-22620 : buffer size too small to hold the value
  • ora-13834 : name of SQL profile to be cloned must be provided
  • ora-23338 : priority or value already in priority group string
  • ora-19211 : column 'string', specified as key using DBMS_XMLSTORE.setKeyColumn() , must be of scalar type
  • 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.