ORA-25193: cannot use COMPRESS option for a single column key

Cause : A nattepmtt ou s eCMOPERS Sotpino no isnlgec oulm nkye

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

Rmeoev hteC OPMRSESo pito.n

update : 28-06-2017

ORA-25193 - cannot use COMPRESS option for a single column key
ORA-25193 - cannot use COMPRESS option for a single column key

  • ora-14007 : missing LESS keyword
  • ora-37129 : (XSCCOMP04) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object. All static MODEL statements must precede all RELATION statements over the bases of the COMPRESSED COMPOSITE.
  • ora-02186 : tablespace resource privilege may not appear with other privileges
  • ora-39036 : invalid metadata filter name string
  • ora-15045 : ASM file name 'string' is not in reference form
  • ora-01328 : only one build operation may occur at one time
  • ora-12407 : unauthorized operation for policy string
  • ora-24803 : illegal parameter value in lob read function
  • ora-29392 : cpu parameters for level string for plan string must be zero
  • ora-07412 : sfaslv: Error getting entry in asynchronous write array.
  • ora-00357 : too many members specified for log file, the maximum is string
  • ora-13360 : invalid subtype in a compound type
  • ora-14453 : attempt to use a LOB of a temporary table, whose data has alreadybeen purged
  • ora-27548 : Unable to unprepare IPC buffer
  • ora-27452 : %s is an invalid name for a database object.
  • ora-28661 : Object already has COMPRESS clause specified
  • ora-09800 : Process sensitivity label retrieval failed.
  • ora-24908 : invalid recipient presentation attribute
  • ora-09975 : kxfspini: Error Initializing SDI Process
  • ora-01413 : illegal value in packed decimal number buffer
  • ora-00280 : change string for thread string is in sequence #string
  • ora-12217 : TNS:could not contact PREFERRED_CMANAGERS in TNSNAV.ORA
  • ora-14277 : tables in EXCHANGE SUBPARTITION must have the same number of columns
  • ora-24324 : service handle not initialized
  • ora-27399 : job type EXECUTABLE requires the CREATE EXTERNAL JOB privilege
  • ora-16516 : the current state is invalid for the attempted operation
  • ora-32314 : REFRESH FAST of "string"."string" unsupported after deletes/updates
  • ora-13524 : error encountered while retrieving baseline information
  • ora-29656 : Invalid option for USING
  • ora-00486 : ASMB process terminated with error
  • 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.