ORA-14517: subpartition of index 'string.string' is in
unusable state



ORA-14517: subpartition of index 'string.string' is in unusable state..

Answer / guest

Cause: An attempt has been made to access an index
subpartition that has been marked unusable by a direct load
or by a DDL operation

Action: REBUILD the unusable index subpartition

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06531: CHANGE ... KEEP not supported for incremental BACKUPSET

1 Answers  


ORA-22634: Error adding new instance to AnyDataSet

1 Answers  


ORA-25157: Specified block size string is not valid

1 Answers  


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.

1 Answers  


ORA-24960: the attribute string is greater than the maximum allowable length of number

1 Answers  






DGM-16999: Instance "string" was not found.

1 Answers  


ORA-25134: keyword TABLE expected

1 Answers  


ORA-06803: TLI Driver: the IPX device file could not be opened

1 Answers  


ORA-12418: user string not found

1 Answers  


ORA-02053: transaction string committed, some remote DBs may be in-doubt

1 Answers  


ORA-13042: invalid SDO_LEVEL and SDO_NUMTILES combination

1 Answers  


ORA-08187: snapshot expression not allowed here

1 Answers  


Categories