ORA-13485: error occurred during compression or decompression: string

Cause : Th eopreatoin ocul dno tbec omlpetde bceaues a nerorr cocurredd urnig ocmperssoin ro dceomrpesison .Chcek hte rero rmessag efo rdeatil.s

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

Chcek htatt heG eoaRstre ojbec tisv aldi, htati tsm etdaat aisv aldi fro teh sepciifedc omrpesisonf oramt,a ndt ha tvaild apraemtesr aer psase dinot teh cmoprsesino o rdeocmperssoin poertaio.n

update : 25-04-2017
ORA-13485

ORA-13485 - error occurred during compression or decompression: string
ORA-13485 - error occurred during compression or decompression: string

  • ora-39701 : database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE
  • ora-25263 : no message in queue string.string with message ID string
  • ora-29549 : class string.string has changed, Java session state cleared
  • ora-29805 : missing COLUMN keyword
  • ora-24790 : cannot mix OCI_TRANS_RESUME and transaction isolation flags
  • ora-32625 : illegal dimension in cell reference predicate
  • ora-24341 : bad mode specified
  • ora-06118 : NETTCP: unable to complete handshake with ORASRV
  • ora-29661 : Unable to find the superclass of the defined in the EXTERNAL NAME
  • ora-16110 : user procedure processing of logical standby apply DDL
  • ora-04084 : cannot change NEW values for this trigger type
  • ora-10906 : Unable to extend segment after insert direct load
  • ora-30188 : reserved for future use
  • ora-28340 : a different encryption algorithm has been chosen for the table
  • ora-09282 : sllfrb: error reading records
  • ora-39106 : Worker process string failed during startup. Worker error:
  • ora-12232 : TNS:No path available to destination
  • ora-02304 : invalid object identifier literal
  • ora-31629 : unable to allocate additional memory
  • ora-22865 : more than one column specified
  • ora-24348 : Update or Delete without Where
  • ora-25335 : AQ array operations not allowed for buffered messages
  • ora-09802 : Conversion of binary label to string failed.
  • ora-06902 : CMX: cannot attach to cmx subsystem
  • ora-10701 : Dump direct loader index keys
  • ora-31624 : A job cannot be modified after it has started.
  • ora-13712 : Cannot perform ADDM analysis on AWR snapshots from previous releases. Snapshot version "string" do not match the database version "string".
  • ora-16563 : unable to add value, syntax error at "string"
  • ora-27376 : event condition cannot be NULL
  • ora-02882 : sou2o: Could not register SGA for protection
  • 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.