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 : 25-04-2017

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

  • ora-13034 : Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object
  • ora-19672 : media management software returned invalid file status
  • ora-38711 : Corrupt flashback log block header: block string
  • ora-29279 : SMTP permanent error: string
  • ora-09771 : osnmwrtbrkmsg: bad return code from msg_send.
  • ora-02881 : sou2o: Could not revoke access to protected memory
  • ora-19502 : write error on file "string", blockno string (blocksize=string)
  • ora-27047 : unable to read the header block of file
  • ora-14020 : this physical attribute may not be specified for a table partition
  • ora-31508 : invalid parameter value for synchronous change set
  • ora-16782 : instance not open for read and write access
  • ora-13463 : error retrieving GeoRaster data: string
  • ora-06431 : ssaio: Invalid Block number
  • ora-31198 : Mismatch in number of bytes transferred due to non-binary mode
  • ora-02082 : a loopback database link must have a connection qualifier
  • ora-30676 : socket read or write failed
  • ora-13187 : subdivision failed
  • ora-00604 : error occurred at recursive SQL level string
  • ora-01298 : conflicting dictionary option
  • ora-28139 : Maximum allowed Fine Grain Audit Policies Exceeded
  • ora-25133 : duplicate SINGLE TABLE option specified
  • ora-13222 : failed to compute supercell for geometry in string
  • ora-13139 : could not obtain column definition for string
  • ora-29887 : cannot support row movement if domain index defined on table
  • ora-01109 : database not open
  • ora-03288 : both FREELIST GROUP and INSTANCE parameters may not be specified
  • ora-00327 : log string of thread string, physical size string less than needed string
  • ora-00151 : invalid transaction ID
  • ora-32772 : BIGFILE is invalid option for this type of tablespace
  • ora-01600 : at most one "string" in clause "string" of 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.