Oracle Database Errors or Warnings from Error ORA-28601 to ORA-28652

SQLServerF1

ORA-28601: invalid [no]MINIMIZE option
Cause: user didn’t type this alter table <table_name> MINIMIZE RECORDS_PER_BLOCK or alter table <table_name> NOMINIMIZE RECORDS_PER_BLOCK
Action: reenter correct sql command
ORA-28602: statement not permitted on tables containing bitmap indexes
Cause: table has bitmap indexes and user is minimizing or nominimizing records_per_block
Action: drop all bitmap indexes before changing records_per_block
ORA-28603: statement not permitted on empty tables
Cause: table is empty and statement does not work on empty tables
Action: try statement after loading your data

ORA-28604: table too fragmented to build bitmap index (string,string,string)
Cause: The table has one or more blocks that exceed the maximum number of rows expected when creating a bitmap index. This is probably due to deleted rows. The values in the message are: (data block address, slot number found, maximum slot allowed)
Action: Defragment the table or block(s). Use the values in the message to determine the FIRST block affected. (There may be others).
ORA-28605: bitmap indexes cannot be reversed
Cause: user tried to create reverse bitmap index
Action: don’t do this; it is not supported
ORA-28606: block too fragmented to build bitmap index (string,string)
Cause: The block(s) exceed the maximum number of rows expected when creating a bitmap index. This is probably due to maximum slot allowed set too low. The values in the message are: (slot number found, maximum slot allowed)
Action: alter system flush shared_pool; update tab$ set spare1 = 8192 where obj# = (select obj# from obj$ where NAME=<table_name> AND owner# = <table_owner>; commit;

ORA-28611: bitmap index is corrupted – see trace file for diagnostics
Cause: Validate Index detected bitmap corruption in its argument index
Action: Drop this bitmap index and create a new one.
ORA-28650: Primary index on an IOT cannot be rebuilt
Cause: An attempt is made to issue alter index rebuild on IOT-TOP
Action: Use Alter table MOVE to reorganize the table(IOT)
ORA-28651: Primary index on IOTs can not be marked unusable
Cause: An attempt is made to mark IOT-TOP unusable thru ALTER INDEX
Action: Remove the option UNUSABLE
ORA-28652: overflow segment attributes cannot be specified
Cause: During ALTER MOVE ONLINE of a index-organized table, the user attempted to enter one or more of the following options: OVERFLOW, PCTTHRESHOLD,INCLUDING.
Action: Remove the illegal option(s).

Above are list of Oracle Database Errors or Warnings from Error ORA-28601 to ORA-28652 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *