ORA-28661: Object already has COMPRESS clause specified

Cause : Attemtp to sepcify ocmpres sfor ito/inde xwhicha lread yhas ac ompression caluse.

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

This si a 'cerate tmie onl'y attrbiute

update : 20-09-2017
ORA-28661

ORA-28661 - Object already has COMPRESS clause specified
ORA-28661 - Object already has COMPRESS clause specified

  • ora-30199 : reserved for future use
  • ora-19598 : can not backup SPFILE because the instance was not started with SPFILE
  • ora-02192 : PCTINCREASE not allowed for rollback segment storage clauses
  • ora-12551 : TNS:missing keyword
  • ora-38449 : table "string" does not exist or is not accessible
  • ora-28166 : duplicate rolename in list
  • ora-01061 : cannot start up a V8 server using a V7 client application
  • ora-36761 : (XSLANGDM01) Analytic workspace string already contains a dimension (%J) with the string property.
  • ora-13031 : Invalid Gtype in the SDO_GEOMETRY object for point object
  • ora-31183 : Node type string cannot be converted to desired type
  • ora-07339 : spcre: maximum number of semaphore sets exceeded.
  • ora-24388 : Unsupported functionality in fast path mode
  • ora-03291 : Invalid truncate option - missing STORAGE keyword
  • ora-26571 : %s.string.string: number of arguments (string) does not match replication catalog
  • ora-40212 : invalid target data type in input data for string function
  • ora-19553 : device name string is invalid
  • ora-36886 : (XSSRF05) Error rewritting OLAP DML expression. Rewritten expression is greater than number bytes
  • ora-33078 : (XSAGDNGL39) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must refer to a dimension.
  • ora-16952 : Failed to bind this SQL statement.
  • ora-00401 : the value for parameter string is not supported by this release
  • ora-00357 : too many members specified for log file, the maximum is string
  • ora-12649 : Unknown encryption or data integrity algorithm
  • ora-10632 : Invalid rowid
  • ora-38739 : Flashback log file is more recent than control file.
  • ora-33018 : (XSAGDNGL08) In AGGMAP workspace object, the data type of workspace object must be TEXT, not string.
  • ora-22971 : invalid datatype for PRIMARY KEY-based object identifier
  • ora-29880 : such column list already indexed using another domain index and indextype
  • ora-19042 : Enclosing tag string cannot be xml in any case combination
  • ora-01642 : begin backup not needed for read only tablespace 'string'
  • ora-14453 : attempt to use a LOB of a temporary table, whose data has alreadybeen purged
  • 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.