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

NID-00130: Mismatched CHECKPOINT_CHANGE# in datafile "string", expecting string, found string

ORA-00296: maximum number of files (string) exceeded for RECOVER DATAFILE LIST

NCR-01007: NCRS: Operation is not supported in a given mode.

ORA-01690: sort area size too small

ORA-01532: cannot create database; instance being started elsewhere

ORA-12060: shape of prebuilt table does not match definition query

ORA-02246: missing EVENTS text

ORA-23410: materialized view "string"."string" is already in a refresh group

ORA-36718: (XSALLOC00) You do not have the necessary permissions to use AGGMAP workspace object.

ORA-13013: the specified topology was not INTERIOR or BOUNDARY

ORA-24046: protocol attribute reserved for future use

TNS-00549: value specified for the SSL version is not valid

For more Oracle Errors Interview Questions Click Here