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 : 28-05-2017
ORA-28661

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

  • ora-00132 : syntax error or unresolved network name 'string'
  • ora-01429 : Index-Organized Table: no data segment to store overflow row-pieces
  • ora-01530 : a database already mounted by the instance
  • ora-25219 : enqueue failed, sequence deviation not allowed for queue string.string
  • ora-10647 : Tablespace other than SYSTEM, string, string not found in read only mode
  • ora-14309 : Total count of list values exceeds maximum allowed
  • ora-23323 : parameter length exceeds deferred RPC limits
  • ora-01556 : MINEXTENTS for rollback segment must be greater than 1
  • ora-39780 : Direct path context operations are not allowed after the context is aborted or finished
  • ora-34243 : (MXDCL11) You can only use the string keyword when defining a COMPOSITE.
  • ora-24185 : transformation string.string does not exist
  • ora-01493 : invalid SAMPLE size specified
  • ora-40283 : missing cost matrix
  • ora-04092 : cannot string in a trigger
  • ora-16591 : unknown field "string" in document
  • ora-01929 : no privileges to GRANT
  • ora-31502 : invalid number supplied for supplemental_processes
  • ora-24769 : cannot forget an active transaction
  • ora-30158 : The OCIFileWrite causes the file to exceed the maximum allowed size
  • ora-07671 : $IDTOASC failed translating an integrity category
  • ora-31622 : ORACLE server does not have string access to the specified file
  • ora-12433 : create trigger failed, policy not applied
  • ora-19755 : could not open change tracking file
  • ora-24380 : invalid mode specification
  • ora-16617 : unknown object identifier specified in request
  • ora-23383 : registration for materialized view repgroup "string"."string" failed at site string
  • ora-36802 : (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH command or a LIMITMAP.
  • ora-14083 : cannot drop the only partition of a partitioned table
  • ora-31490 : could not attach to LogMiner session
  • ora-33022 : (XSAGDNGL10) The measure dimension workspace object must be a TEXT or ID base dimension that does not dimension AGGMAP workspace object, but is in the same analytic workspace.
  • 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.