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 - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

drop all bitmap indexes before changing records_per_block

update : 16-08-2017

ORA-28602 - statement not permitted on tables containing bitmap indexes
ORA-28602 - statement not permitted on tables containing bitmap indexes

  • ora-16953 : Type of SQL statement not supported.
  • ora-02248 : invalid option for ALTER SESSION
  • ora-29545 : badly formed class: string
  • ora-29862 : cannot specify FORCE option for dropping non-domain index
  • ora-33080 : (XSAGDNGL40) In AGGMAP workspace object, you cannot reference dimension workspace object with both a RELATION statement and a DIMENSION statement.
  • ora-14610 : Lob attributes not specified for lob column string for subpartition string
  • ora-29396 : cannot switch group to string
  • ora-06530 : Reference to uninitialized composite
  • ora-32586 : multiple specification of a supplemental logging attribute
  • ora-28558 : HS_FDS_CONNECT_STRING undefined for non-Oracle system
  • ora-16014 : log string sequence# string not archived, no available destinations
  • ora-01590 : number of segment free list (string) exceeds maximum of string
  • ora-24815 : Invalid character set form
  • ora-01039 : insufficient privileges on underlying objects of the view
  • ora-01221 : data file string is not the same file to a background process
  • ora-04065 : not executed, altered or dropped string
  • ora-09987 : unable to attach to SGA in READ-ONLY mode
  • ora-07233 : slemcw: invalid file handle, seals do not match.
  • ora-01298 : conflicting dictionary option
  • ora-16217 : prepare to switchover has not completed
  • ora-13631 : The task string contains no execution results.
  • ora-01944 : IDENTIFIED EXTERNALLY already specified
  • ora-09890 : osnTXtt: malloc failed
  • ora-13766 : A ranking measure is required.
  • ora-29968 : No primary operator bindings found for ancillary binding #string
  • ora-28155 : user 'string' specified as a proxy is actually a role
  • ora-13150 : failed to insert exception record
  • ora-28522 : error initializing heterogeneous capabilities
  • ora-28506 : parse error in data dictionary translation for string stored in string
  • ora-02454 : Number of hash keys per block (string) exceeds maximum of string
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.