ORA-14079: illegal option for a partition marked Index Unusable

Cause : ALTERI NDEX OMDIFY APRTITINO statmeent aaginst na inde xpartiiton makred Inedx Unuasble cnotaine dSTORAEG and/ro DEALOLCATE PSACE caluses hwich i sillegla

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

Ensur ethat noly vaild optnis ares pecifeid

update : 30-05-2017
ORA-14079

ORA-14079 - illegal option for a partition marked Index Unusable
ORA-14079 - illegal option for a partition marked Index Unusable

  • ora-31056 : The document being inserted does not conform to string
  • ora-26530 : unable to build materialized view refresh control list
  • ora-10654 : Table is of type temporary or external
  • ora-25218 : enqueue failed, delay must be zero for queue string.string
  • ora-25206 : enqueue failed, enqueue to exception queue string.string not permitted
  • ora-07503 : scgcmn: $setimr unexpected return
  • ora-10581 : Can not modify redo log header during test recovery
  • ora-38466 : user does not have privileges to CREATE/MODIFY expressions
  • ora-30027 : Undo quota violation - failed to get string (bytes)
  • ora-32612 : invalid use of FOR loop
  • ora-30389 : the source statement is not compatible with the destination statement
  • ora-37060 : (XSMCSESS08) number is not a valid custom member in dimension workspace object.
  • ora-31449 : invalid value for change_set_name
  • ora-24813 : cannot send or receive an unsupported LOB
  • ora-22600 : encountered 8.0.2 (Beta) VARRAY data that cannot be processed
  • ora-39216 : object type "string"."string" hashcode mismatch
  • ora-10635 : Invalid segment or tablespace type
  • ora-06928 : CMX: wrong ORACLE_SID
  • ora-16218 : This database is already preparing to switch over.
  • ora-12021 : materialized view "string"."string" is corrupt
  • ora-36376 : (XSAGZERO) AGGREGATE attempted to divide by zero. Set DIVIDEBYZERO to YES if you want NA to be returned as the result of a division by zero.
  • ora-14068 : TABLESPACE and TABLESPACE_NUMBER may not be both specified
  • ora-14110 : partitioning column may not be of type ROWID
  • ora-12488 : maximum label does not dominate minimum label
  • ora-28546 : connection initialization failed, probable Net8 admin error
  • ora-03297 : file contains used data beyond requested RESIZE value
  • ora-12550 : TNS:syntax error
  • ora-24193 : the property value exceeds the valid range string
  • ora-25443 : duplicate column value for table alias: string, column number: string
  • ora-23497 : repgroup name cannot be null
  • 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.