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 : 23-05-2017
ORA-28602

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

  • ora-00128 : this command requires a dispatcher name
  • ora-13062 : topology IDs do not match in the feature table and the topology
  • ora-08268 : create_ora_addr: cannot close nameserver
  • ora-02247 : no option specified for ALTER SESSION
  • ora-02427 : create view failed
  • ora-33074 : (XSAGDNGL36) In AGGMAP workspace object, the offset number is not a valid offset into dimension workspace object.
  • ora-16633 : the only instance of the database cannot be removed
  • ora-27011 : skgfrd: cannot read from file opened for write
  • ora-06959 : Buffer I/O quota is too small
  • ora-24407 : connection pool already exists
  • ora-02184 : resource quotas are not allowed in REVOKE
  • ora-02877 : smpini: Unable to initialize memory protection
  • ora-06439 : ssaio: the asynchronous write returned incorrect number of bytes
  • ora-32825 : Messaging Gateway agent has not been started
  • ora-40262 : NMF: number of features not between [1, string]
  • ora-22808 : REF dereferencing not allowed
  • ora-38901 : column "string" of table "string" must be one of the first "number" columns
  • ora-19715 : invalid format string for generated name
  • ora-28052 : the account is disabled
  • ora-06756 : TLI Driver: cannot open oratab
  • ora-12479 : file label string must equal DBHIGH string
  • ora-19300 : Error occurred in uri processingstring
  • ora-39015 : job is not running
  • ora-22886 : scoped table "string" in schema "string" is not an object table
  • ora-19646 : cannot change size of datafile string from string to string
  • ora-00385 : cannot enable Very Large Memory with new buffer cache parameters
  • ora-36836 : (XSLMGEN06) Dimension string.string!string hierarchy string level string is missing a PHYSICALNAME property value
  • ora-01172 : recovery of thread string stuck at block string of file string
  • ora-13801 : invalid value for SQLTUNE_CATEGORY parameter
  • ora-19601 : output file is string string (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.