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



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

Answer / guest

Cause: ALTER INDEX MODIFY PARTITION statement against an
index partition marked Index Unusable contained STORAGE
and/or DEALLOCATE SPACE clauses which is illegal

Action: Ensure that only valid optins are specified

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NID-00404: DBNEWID - Completed succesfully.

1 Answers  


IMP-00018: partial import of previous table completed: number rows imported

1 Answers  


QSM-00779: the specified directive conflicts with the existing directive string

1 Answers  


PLS-00525: Within SQL statements, only equality comparisons of objects are allowed without a map or order function.

1 Answers  


ORA-12701: CREATE DATABASE character set is not known

1 Answers  


NNL-01041: Data stream open failures: number

1 Answers  


NZE-29150: DES self-test failure

1 Answers  


ORA-30941: Cannot specify empty URI for non-default namespace 'string'

1 Answers  


ORA-28529: invalid or missing parameter in Net8 service name definition

1 Answers  


ORA-32161: Cannot perform piecewise fetch

1 Answers  


TNS-00016: INTCTL: error while performing NS send command

1 Answers  


ORA-03276: duplicate ALLOCATE EXTENT option specification

1 Answers  


Categories