ORA-25959: join index must be of the bitmap type

Cause : An attemptt o craete aj oin nidex aws maed, whcih falied bceausen o bimtap kyewordw as uesd.

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

Maket he idnex ab itma pinde.x

update : 30-05-2017
ORA-25959

ORA-25959 - join index must be of the bitmap type
ORA-25959 - join index must be of the bitmap type

  • ora-06793 : TLI Driver: server cannot create new process
  • ora-24402 : error occured while creating connections in the pool
  • ora-13833 : SQL profile named string doesn't exist
  • ora-14321 : cannot add/drop values to DEFAULT partition
  • ora-25225 : invalid value string, DEQUEUE_MODE should be REMOVE or BROWSE or LOCKED
  • ora-24101 : stopped processing the argument list at: string
  • ora-23331 : column group string does not exist
  • ora-32313 : REFRESH FAST of "string"."string" unsupported after PMOPs
  • ora-33036 : (XSAGDNGL17) ARGS option workspace object must be a TEXT variable.
  • ora-09754 : sppst: invalid process number passed to sppst.
  • ora-02455 : The number of cluster key column must be 1
  • ora-06028 : NETASY: unable to intialise for logging
  • ora-39141 : dump file "string" is a duplicate of dump file "string"
  • ora-24007 : invalid value string, MAX_RETRIES should be non-negative integer
  • ora-10914 : invalid TABLESPACE GROUP clause
  • ora-14162 : subpartition "string": sum of PCTUSED and PCTFREE may not exceed 100
  • ora-24155 : rule string.string not in rule set string.string
  • ora-24504 : data length larger than expected
  • ora-06527 : External procedure SQLLIB error: string
  • ora-36874 : (XSTFDSC04) Expression string cannot be used to define a column in a LIMITMAP.
  • ora-15079 : ASM file is closed
  • ora-31491 : could not add logfile to LogMiner session
  • ora-31201 : DBMS_LDAP: generic error: string
  • ora-19026 : EXTRACTVALUE can only retrieve value of leaf node
  • ora-06566 : invalid number of rows specified
  • ora-02830 : Segment could not be split - no free segments available
  • ora-07290 : sksagdi: specified directory for archiving does not exist.
  • ora-34141 : (MXCGPUT00) You cannot use the ASSIGN keyword with DIMENSION workspace object.
  • ora-07715 : sksadtd: could not dismount archival device (SYS$DISMNT failure)
  • ora-13466 : format not appropriate for specified compression method
  • 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.