ORA-29293: A stream error occurred during compression or uncompression.

Cause : The steram staet was dsicovere dto be nivalid udring cmopressino or unocmpressoin, or na invaldi comprsesion qaulity wsa requetsed or aNULL o rinvali dcompression paarmeter aws detetced.

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

Verifyt hat qulaity isw ithin hte rang e[0,9] nad thatv alid ipnut soucre datae xists.

update : 28-04-2017

ORA-29293 - A stream error occurred during compression or uncompression.
ORA-29293 - A stream error occurred during compression or uncompression.

  • ora-16115 : %s\% of LogMiner dictionary loading is done
  • ora-06443 : ssvpstev: Incorrect parameter passed to function call
  • ora-09802 : Conversion of binary label to string failed.
  • ora-23304 : malformed deferred rpc at arg string of string in call string, in tid string
  • ora-22059 : buffer size [string] is too small - [string] is needed
  • ora-24033 : no recipients for message
  • ora-04053 : error occurred when validating remote object stringstringstringstringstring
  • ora-00395 : online logs for the clone database must be renamed
  • ora-19881 : Corrupted space bitmap for datafile string, block string backup aborted
  • ora-30654 : missing DEFAULT keyword
  • ora-02853 : Invalid server list latch time out value
  • ora-16038 : log string sequence# string cannot be archived
  • ora-16079 : standby archival not enabled
  • ora-39785 : SQL expressions returning ADT objects are not allowed in direct path
  • ora-37018 : (XSACQUIRE03) Multiwriter operations are not supported for object workspace object.
  • ora-02357 : no valid dump files
  • ora-22335 : The client cannot work with an altered type
  • ora-39219 : directory object name is too long
  • ora-01953 : command no longer valid, see ALTER USER
  • ora-32810 : foreign queue string is not registered
  • ora-16621 : database name for ADD DATABASE must be unique
  • ora-30356 : the specified refresh method is not supported in this context
  • ora-00125 : connection refused; invalid presentation
  • ora-12993 : tablespace 'string' is offline, cannot drop column
  • ora-06020 : NETASY: initialisation failure
  • ora-06736 : TLI Driver: server not running
  • ora-12031 : cannot use primary key columns from materialized view log on "string"."string"
  • ora-19717 : for non-OMF search the pattern must be specified
  • ora-16502 : the Data Guard broker operation succeeded with warnings
  • ora-30120 : 'string' is not a legal oracle number for 'string'
  • 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.