ORA-28651: Primary index on IOTs can not be marked unusable

Question Posted / guest

ORA-28651: Primary index on IOTs can not be marked unusable..

Answer / guest

Cause: An attempt is made to mark IOT-TOP unusable thru
ALTER INDEX

Action: Remove the option UNUSABLE

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

More Oracle Errors Interview Questions

AMD-00119: analytic workspace dimensions not specified in input

ORA-14012: resulting partition name conflicts with that of an existing partition

QSM-01082: Joining materialized view, string, with table, string, not possible

ORA-12589: TNS:connection not bequeathable

ORA-01096: program version (string) incompatible with instance (string)

QSM-00514: the size of must-retain summaries exceeds specified space limit

PLS-00390: undefined column 'string' in INSERT statement

ORA-01917: user or role 'string' does not exist

ORA-06600: LU6.2 Driver: SNA software is not loaded

ORA-03008: parameter COMPATIBLE >= string needed for string

ORA-31108: Action failed as resource string is locked

ORA-16009: remote archive log destination must be a STANDBY database

For more Oracle Errors Interview Questions Click Here