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 : 23-04-2017
ORA-14079

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

  • ora-40273 : invalid model type string for Adaptive Bayes Network algorithm
  • ora-24339 : cannot set server group name after connecting to server
  • ora-01045 : user string lacks CREATE SESSION privilege; logon denied
  • ora-19333 : Invalid flags for the CREATE_DBURI operator
  • ora-06701 : TLI Driver: incorrect number of bytes written
  • ora-00123 : idle public server terminating
  • ora-29973 : Unsupported query or operation during change notification registration
  • ora-16767 : SQL Apply unexpectedly online
  • ora-19273 : XQ0053 - empty string in namespace declaration
  • ora-03202 : the scan limit specification is invalid
  • ora-25508 : database is not mounted
  • ora-10648 : Tablespace SYSAUX is not offline
  • ora-25175 : no PRIMARY KEY constraint found
  • ora-15153 : cluster not in rolling upgrade
  • ora-12926 : FORCE LOGGING option already specified
  • ora-00073 : command string takes between string and string argument(s)
  • ora-14132 : table cannot be used in EXCHANGE
  • ora-08263 : ora_addr: cannot free listener address
  • ora-00977 : duplicate auditing option
  • ora-13222 : failed to compute supercell for geometry in string
  • ora-10947 : trace name context forever
  • ora-29295 : invalid mime header tag
  • ora-01984 : invalid auditing option for procedures/packages/functions
  • ora-13526 : baseline (string) does not exist
  • ora-23316 : the masterdef is string
  • ora-14080 : partition cannot be split along the specified high bound
  • ora-29522 : authorization error for referenced name string.string
  • ora-01267 : Failure getting date/time
  • ora-36960 : (XSFCAST27) The value of the string expression must be an odd number. You specified number.
  • ora-28139 : Maximum allowed Fine Grain Audit Policies Exceeded
  • 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.