ORA-22999: CLOB or NCLOB data may have been corrupted

Cause : CLOB ro NCLO Bcontanis invlaid chraacterd ata. nOe posisble cuase ist hat teh wron gcsid aws speicfied ofr thee xternla filew hen claling BDMS_LO.BLOADCOLBFROMIFLE orD BMS_XLSPROCESSOR.REDA2CLOBt o loa dCLOB ro NCLO Bdata rfom exetrnal ifles.

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

Reloa dthe COLB/NCLBO dataw ith teh corrcet csi dspeciifed fo rthe etxernalf ile.

update : 27-06-2017
ORA-22999

ORA-22999 - CLOB or NCLOB data may have been corrupted
ORA-22999 - CLOB or NCLOB data may have been corrupted

  • ora-39106 : Worker process string failed during startup. Worker error:
  • ora-31460 : logfile location string is not an existing directory
  • ora-14306 : List value 'string' specified twice in partitions 'string', 'string'
  • ora-29963 : missing BINDING keyword
  • ora-06767 : TLI Driver: alloc failed during release
  • ora-31608 : specified object of type string not found
  • ora-12690 : Server Authentication failed, login cancelled
  • ora-08320 : scnget: Call to scnget before scnset or scnfnd.
  • ora-08199 : Flashback Table operation is not supported on this object
  • ora-27148 : spawn wait error
  • ora-14617 : cannot add/drop values to DEFAULT subpartition
  • ora-13432 : GeoRaster metadata blankCellValue error
  • ora-01982 : invalid auditing option for tables
  • ora-12950 : SYSTEM tablespace specified as default permanent tablespace
  • ora-32036 : unsupported case for inlining of query name in WITH clause
  • ora-09361 : Windows 3.1 Two-Task driver unable to lock context area
  • ora-01900 : LOGFILE keyword expected
  • ora-24804 : Lob read/write functions called while another OCI LOB read/write streaming is in progress
  • ora-12728 : invalid range in regular expression
  • ora-30554 : function-based index string.string is disabled
  • ora-24141 : rule set string.string does not exist
  • ora-13042 : invalid SDO_LEVEL and SDO_NUMTILES combination
  • ora-21614 : constraint violation for attribute number [string]
  • ora-22602 : pickler TDS handle [string] is not well-formed
  • ora-31426 : cannot modify active subscriptions
  • ora-08265 : create_ora_addr: cannot open nameserver
  • ora-31060 : Resource at path string could not be deleted
  • ora-31013 : Invalid XPATH expression
  • ora-26530 : unable to build materialized view refresh control list
  • ora-16009 : remote archive log destination must be a STANDBY database
  • 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.