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



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

Post New Answer

More Oracle Errors Interview Questions

ORA-26577: PRESERVE TABLE can not be used when dropping old style materialized view string.string

1 Answers  


ORA-01212: MAXLOGMEMBERS may not exceed string

1 Answers  


ORA-03289: partition name and segment type do not match

1 Answers  


ORA-29508: query derived from USING clause did not select a value of type string

1 Answers  


ORA-25110: NOSORT may not be used with a bitmap index

1 Answers  






ORA-24037: schema string in QUEUE_NAME is not same as schema string in QUEUE_TABLE

1 Answers  


PROC-00007: Cannot perform cluster registry operation because key handle is invalid.

1 Answers  


ORA-16768: Logical apply service unexpectedly offline

1 Answers  


PCC-00015: Unrecognized Host Language syntax ignored at line number in file string

1 Answers  


ORA-22297: warning: Open LOBs exist at transaction commit time

1 Answers  


ORA-30031: the suspended (resumable) statement has been aborted

1 Answers  


ORA-19801: initialization parameter DB_RECOVERY_FILE_DEST is not set

1 Answers  


Categories