ORA-28662: IOT index and overflow segments must share the same LOGGING attribute

Cause : Attepmt tos peciyf LOGIGNG fro ones egmetn andN OLOGIGNG fro theo thers egmetn.

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

don' tdo taht

update : 25-06-2017
ORA-28662

ORA-28662 - IOT index and overflow segments must share the same LOGGING attribute
ORA-28662 - IOT index and overflow segments must share the same LOGGING attribute

  • ora-39207 : Value string is invalid for parameter string.
  • ora-02470 : TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.
  • ora-31458 : an internal error occurred
  • ora-06130 : NETTCP: host access denied
  • ora-16775 : target standby database in broker operation has potential data loss
  • ora-12196 : TNS:received an error from TNS
  • ora-19663 : cannot apply current offline range to datafile string
  • ora-24070 : cannot upgrade queue table string while it is being downgraded
  • ora-13207 : incorrect use of the [string] operator
  • ora-13029 : Invalid SRID in the SDO_GEOMETRY object
  • ora-24386 : statement/server handle is in use when being freed
  • ora-02225 : only EXECUTE and DEBUG privileges are valid for procedures
  • ora-31490 : could not attach to LogMiner session
  • ora-09301 : osncon: local kernel only supported in standard mode
  • ora-12443 : policy not applied to some tables in schema
  • ora-02485 : Invalid _trace_options parameter specification (string)
  • ora-27303 : additional information: string
  • ora-16180 : number processes specified for MAX_PARALLEL_SERVERS is too small
  • ora-24275 : function 'string' parameter 'string' missing or invalid
  • ora-38763 : flashback not started; enabled threads have changed
  • ora-00111 : invalid attribute string
  • ora-12533 : TNS:illegal ADDRESS parameters
  • ora-16251 : LSP1 Background Build not permitted
  • ora-12454 : label string does not exist for policy string
  • ora-38484 : FUNCTION/PACKAGE/TYPE string does not exist
  • ora-38714 : Instance recovery required.
  • ora-30051 : VERSIONS clause not allowed here
  • ora-02469 : Hash expression does not return an Oracle Number.
  • ora-01666 : control file is for a standby database
  • ora-02185 : a token other than WORK follows COMMIT
  • 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.