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 : 23-05-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-14318 : DEFAULT partition must be last partition specified
  • ora-09369 : Windows 3.1 Two-Task driver bad instance handle
  • ora-12463 : undefined group string for policy string
  • ora-28029 : could not authorize remote server for user string
  • ora-16162 : Cannot add new standby databases to protected configuration
  • ora-06794 : TLI Driver: shadow process could not retrieve protocol info
  • ora-19211 : column 'string', specified as key using DBMS_XMLSTORE.setKeyColumn() , must be of scalar type
  • ora-14640 : add/coalesce index partition operation is valid only for hash partitioned global indexes
  • ora-12029 : LOB columns may not be used as filter columns
  • ora-12688 : Login failed: the SecurID server rejected the new pincode
  • ora-22996 : NEXT extent size is smaller than LOB chunksize
  • ora-31449 : invalid value for change_set_name
  • ora-29927 : error in executing the ODCIStatsCollect / ODCIStatsDelete routine
  • ora-23614 : Script string does not exist
  • ora-30686 : no dispatcher accepted TCP/IP connection request
  • ora-36206 : (XSAGOP04R) In AGGMAP workspace object, REMOPERATOR string must be MIN, MAX, FIRST, LAST, HFIRST or HLAST.
  • ora-16532 : Data Guard broker configuration does not exist
  • ora-07497 : sdpri: cannot create trace file 'string'; errno = string.
  • ora-25334 : Buffered propagation must restart as the destination queue was recreated/moved
  • ora-01512 : error renaming log file string - new file string not found
  • ora-15051 : file 'string' contains string error(s)
  • ora-26083 : unsupported direct path stream version string
  • ora-33278 : (DBERR09) Analytic workspace string cannot be attached in RW or EXCLUSIVE mode until the changes made and updated in MULTI mode are committed or rolled back.
  • ora-30390 : the source statement is not equivalent to the destination statement
  • ora-29846 : cannot create a local domain index on a string partitioned table
  • ora-12737 : Instant Client Light: unsupported server character set string
  • ora-01575 : timeout waiting for space management resource
  • ora-07804 : slpdtb: number too large for supplied buffer
  • ora-31652 : command response message was invalid type - detaching job
  • ora-12482 : internal MLS error: string Error: string
  • 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.