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 : 17-08-2017
ORA-25193

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

  • ora-01804 : failure to initialize timezone information
  • ora-14620 : DEFAULT subpartition already exists
  • ora-39132 : object type "string"."string" already exists with different hashcode
  • ora-39030 : invalid file type string
  • ora-16655 : specified target standby database invalid
  • ora-19666 : cannot do incremental restore of the control file
  • ora-22977 : missing or invalid attribute
  • ora-13005 : recursive HHCODE function error
  • ora-15009 : ASM disk "string" does not exist
  • ora-26048 : Scoped REF column has wrong table name.
  • ora-24348 : Update or Delete without Where
  • ora-00061 : another instance has a different DML_LOCKS setting
  • ora-12806 : could not get background process to hold enqueue
  • ora-12052 : cannot fast refresh materialized view string.string
  • ora-32515 : cannot issue ORADEBUG command; waited number ms for process string
  • ora-37011 : (XSACQUIRE_LOCKED) Object workspace object is locked by another user.
  • ora-00324 : log file 'string' translated name 'string' too long, string characters exceeds string limit
  • ora-26716 : message limit reached
  • ora-07548 : sftopn: Maximum number of files already open
  • ora-30341 : dropped level has references
  • ora-22918 : specified column or attribute is not a VARRAY type
  • ora-22337 : the type of accessed object has been evolved
  • ora-28674 : cannot reference transient index-organized table
  • ora-31429 : subscription has not been activated
  • ora-16726 : the external condition supplied to resource guard is invalid
  • ora-23420 : interval must evaluate to a time in the future
  • ora-23450 : flavor already contains object "string"."string"
  • ora-23474 : definition of "string"."string" has changed since generation of replication support
  • ora-25114 : invalid file number specified in the DUMP DATAFILE/TEMPFILE command
  • ora-08322 : scnmin: open/convert of bias lock failed
  • 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.