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 : 26-04-2017
ORA-28602

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

  • ora-33443 : (ESDREAD14) Discarding compiled code for workspace object because analytic workspace string is not attached.
  • ora-16527 : unable to allocate SGA heap
  • ora-32166 : Cannot get XA connection
  • ora-06574 : Function string references package state, cannot execute remotely
  • ora-15183 : ASMLIB initialization error [string]
  • ora-19562 : file string is empty
  • ora-24329 : invalid character set identifier
  • ora-08238 : smsfre: cannot detach from SGA
  • ora-30990 : insufficient privileges to change owner of resource string
  • ora-07576 : sspexst: $GETJPIW failure on process ID string
  • ora-30935 : XML maxoccurs value (string) exceeded
  • ora-09369 : Windows 3.1 Two-Task driver bad instance handle
  • ora-22984 : view query cannot contain references to a super view
  • ora-09978 : skxfqhdel: Error Disconnecting from another endpoint.
  • ora-17500 : ODM err:string
  • ora-31521 : CDC subscription string already subscribes to publication ID string column string
  • ora-32107 : internal OCI memory allocation failure
  • ora-06525 : Length Mismatch for CHAR or RAW data
  • ora-28105 : cannot create security relevant column policy in an object view
  • ora-16718 : failed to locate database object
  • ora-14639 : SUBPARTITIONS clause can be specfied only for Hash, Composite Range Hash table/partition
  • ora-31196 : XML nodes over string in size cannot be printed
  • ora-28529 : invalid or missing parameter in Net8 service name definition
  • ora-00208 : number of control file names exceeds limit of string
  • ora-01913 : EXCLUSIVE keyword expected
  • ora-32123 : Attribute number is out of range
  • ora-02484 : Invalid _trace_buffers parameter specification (string)
  • ora-01984 : invalid auditing option for procedures/packages/functions
  • ora-38466 : user does not have privileges to CREATE/MODIFY expressions
  • ora-16008 : indeterminate control file checkpoint
  • 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.