ORA-29854: keyword BITMAP may not be used in creating domain indexes

Cause : An attepmt was mdae to craete a doamin inde xwith th eBITMAP tatribute.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Remove IBTMAP frmo the CRAETE INDE Xstatemetn.

update : 26-05-2017

ORA-29854 - keyword BITMAP may not be used in creating domain indexes
ORA-29854 - keyword BITMAP may not be used in creating domain indexes

  • ora-32740 : The requested operation cannot be proceeded
  • ora-12449 : Labels specified for user must be of type USER
  • ora-39766 : invaid stream specified for column array conversion
  • ora-22879 : cannot use the LOB INDEX clause for partitioned tables
  • ora-13356 : adjacent points in a geometry are redundant
  • ora-37185 : length of string (string) exceeds maximum (string)
  • ora-23439 : refresh group template already exists
  • ora-15080 : synchronous I/O operation to a disk failed
  • ora-13783 : invalid tuning scope
  • ora-31468 : cannot process DDL change record
  • ora-22330 : cannot alter a type that is not valid
  • ora-24411 : Session pool already exists.
  • ora-14169 : invalid ALTER TABLE MODIFY SUBPARTITION option
  • ora-37138 : (XSCCOMP13) You cannot delete values from workspace object because it is an aggregated COMPRESSED COMPOSITE.
  • ora-29351 : can not transport system, sysaux, or temporary tablespace 'string'
  • ora-09362 : Windows 3.1 Two-Task driver unable to deallocate context area
  • ora-27101 : shared memory realm does not exist
  • ora-01029 : internal two task error
  • ora-15117 : command only operates on one diskgroup
  • ora-15043 : ASM disk "string" is not a diskgroup member
  • ora-31692 : The following SQL statement failed trying to insert a row into the Master table: string
  • ora-39128 : unexpected DbmsJava error number from statement string
  • ora-16002 : database already open for read-write access by another instance
  • ora-37172 : illegal dimension type
  • ora-01603 : illegal grouping size in clause "string" of string
  • ora-15202 : cannot create additional ASM internal change segment
  • ora-19262 : XQ0042 - namespace constructor not inside an element constructor
  • ora-13185 : failed to generate initial HHCODE
  • ora-12219 : TNS:missing community name from address in ADDRESS_LIST
  • ora-01027 : bind variables not allowed for data definition operations
  • 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.