ORA-28665: table and partition must have same compression attribute

Cause : sUrea ttmetpdet oXEHCNAEGa c morpseisnoe anlbdep raititnow ti h aocpmerssoi nidaslbdet baelo rivecv reasO Rht e #foc lomusnc morpsees dsid fiefertnf rot baela dnp raititno

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

aMeks ru eht eocpmerssoi ntartbitusem tahcI fhtyed not' ,if xtiu isgnA TLRET BAELM VO EP[RAITITNO ]OCPMERSS

update : 16-08-2017
ORA-28665

ORA-28665 - table and partition must have same compression attribute
ORA-28665 - table and partition must have same compression attribute

  • ora-22339 : cannot alter to not final since its attribute column is substitutable
  • ora-36200 : (XSAGGR34) AGGREGATE operator string requires a WEIGHTBY clause, but ARGS variable workspace object did not specify one.
  • ora-25141 : invalid EXTENT MANAGEMENT clause
  • ora-31529 : could not find publication for CDC subscriber view string.string
  • ora-24812 : character set conversion to or from UCS2 failed
  • ora-12052 : cannot fast refresh materialized view string.string
  • ora-39200 : Link name "string" is invalid.
  • ora-16116 : no work available
  • ora-06423 : NETCMN: Error in receiving data
  • ora-06601 : LU6.2 Driver: Invalid database ID string
  • ora-12231 : TNS:No connection possible to destination
  • ora-01311 : Illegal invocation of the mine_value function
  • ora-16769 : the physical standby database is open read-only
  • ora-16640 : CRS warns that multiple instances may still be running
  • ora-15006 : template "string" does not exist
  • ora-19930 : file string has invalid checkpoint SCN string
  • ora-29972 : user does not have privilege to change/ create registration
  • ora-19592 : wrong string conversation type
  • ora-37037 : (XSMLTDCL03) You cannot RENAME objects in analytic workspace string because it is attached in MULTI mode.
  • ora-01080 : error in shutting down ORACLE
  • ora-07211 : slgcs: gettimeofday error, unable to get wall clock.
  • ora-27062 : could not find pending async I/Os
  • ora-22904 : invalid reference to a nested table column
  • ora-04020 : deadlock detected while trying to lock object stringstringstringstringstring
  • ora-00722 : Feature "string"
  • ora-08458 : invalid format parameter
  • ora-27124 : unable to detach from shared memory segment
  • ora-33280 : (DBERR10) Analytic workspace string cannot be attached in MULTI mode until the changes made and updated in RW or EXCLUSIVE mode are committed or rolled back.
  • ora-14064 : Index with Unusable partition exists on unique/primary constraint key
  • ora-07840 : sllfop: LIB$GET_VM failure
  • 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.