ORA-25122: Only LOCAL bitmap indexes are permitted on partitioned tables

Cause : A nattepmtw a smdaet oc raet eag lboa lbtimpa nidxe no apratoinde atbel.

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

ceraet alcoa lbtimpa nidxe niseta.d

update : 20-08-2017
ORA-25122

ORA-25122 - Only LOCAL bitmap indexes are permitted on partitioned tables
ORA-25122 - Only LOCAL bitmap indexes are permitted on partitioned tables

  • ora-09802 : Conversion of binary label to string failed.
  • ora-16550 : truncated result
  • ora-16624 : broker protocol version mismatch detected
  • ora-24009 : invalid value string, QUEUE_TYPE should be NORMAL_QUEUE or EXCEPTION_QUEUE
  • ora-24769 : cannot forget an active transaction
  • ora-19041 : Comment data cannot contain two consecutive '-'s
  • ora-22899 : cannot specify both scope and rowid constraint on ref column
  • ora-16651 : requirements not met for enabling Fast-Start Failover
  • ora-01155 : the database is being opened, closed, mounted or dismounted
  • ora-29320 : datafile header error
  • ora-12155 : TNS:received bad datatype in NSWMARKER packet
  • ora-13343 : a polygon geometry has fewer than four coordinates
  • ora-33078 : (XSAGDNGL39) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must refer to a dimension.
  • ora-30387 : invalid rewrite mode for REWRITE_EQUIVALENCE API
  • ora-08435 : PICTURE MASK missing the leading sign when SIGN IS LEADING specified
  • ora-13143 : invalid POLYGON window definition
  • ora-09718 : osnsui: cannot set up user interrupt handler.
  • ora-19577 : file string is MISSING
  • ora-06521 : PL/SQL: Error mapping function
  • ora-36389 : (XSAGPARTDEP01) Can not aggregate from PARTITION number into PARTITION number due to increasing sparsity along DIMENSION %J.
  • ora-26022 : index string.string was made unusable due to:
  • ora-09754 : sppst: invalid process number passed to sppst.
  • ora-38103 : Invalid column in the UPDATE SET Clause: string
  • ora-12823 : default degree of parallelism may not be specified here
  • ora-07572 : szrfc: insufficient rolename buffer space
  • ora-10854 : Sets poll count used for AQ listen code under RAC
  • ora-24077 : cannot create propagation schedule for EXCEPTION queue string.string
  • ora-25288 : AQ HTTP propagation encountered error, status-code number, string
  • ora-38101 : Invalid column in the INSERT VALUES Clause: string
  • ora-16232 : adding Logical Standby skip entry for table 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.