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 : 30-04-2017
ORA-28665

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

  • ora-23542 : dependent object "string"."string" already registered
  • ora-06916 : CMX: error in data read (t_datain)
  • ora-32009 : cannot reset the memory value for instance string from instance string
  • ora-19751 : could not create the change tracking file
  • ora-13291 : conversion error between the specified unit and standard unit
  • ora-27417 : BYWEEKNO clause is only supported when FREQ=YEARLY
  • ora-13333 : invalid LRS measure
  • ora-08320 : scnget: Call to scnget before scnset or scnfnd.
  • ora-22162 : element at index [string] has been previously deleted
  • ora-26006 : Incorrect bind variable in column string's sql expression - string
  • ora-10841 : Default un-inintialized charact set form to SQLCS_IMPLICIT
  • ora-26502 : error resignal
  • ora-30971 : illegal operation on the Path Table
  • ora-39068 : invalid master table data in row with PROCESS_ORDER=string
  • ora-14085 : partitioned table cannot have column with LONG datatype
  • ora-29932 : the type being dropped is a statistics type
  • ora-03247 : Invalid block number specified
  • ora-07270 : spalck: setitimer error, unable to set interval timer.
  • ora-28175 : incorrect certificate type
  • ora-39082 : Object type string created with compilation warnings
  • ora-28510 : heterogeneous database link initialization failed
  • ora-16742 : the standby database "string" has exhausted its quota
  • ora-26669 : parameter string inconsistent with parameter string
  • ora-29293 : A stream error occurred during compression or uncompression.
  • ora-06443 : ssvpstev: Incorrect parameter passed to function call
  • ora-30351 : query rewrite does not currently support this expression
  • ora-31639 : unexpected data found
  • ora-15003 : diskgroup "string" already mounted in another lock name space
  • ora-12592 : TNS:bad packet
  • ora-19766 : missing CHANGE keyword
  • 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.