ORA-14086: a partitioned index may not be rebuilt as a whole

Cause : User attempted to rebuild a partitioned index using ALTER INDEX REBUILD statement, which is illegal

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

Rebuild the index a partition at a time (using ALTER INDEX REBUILD PARTITION) or drop and recreate the entire index

update : 29-06-2017

ORA-14086 - a partitioned index may not be rebuilt as a whole
ORA-14086 - a partitioned index may not be rebuilt as a whole

  • ora-25141 : invalid EXTENT MANAGEMENT clause
  • ora-07745 : slemcl: $CLOSE failure
  • ora-15029 : disk 'string' is already mounted by this instance
  • ora-12030 : cannot create a fast refresh materialized view
  • ora-37016 : (XSACQUIRE01) You must specify objects to acquire for the ACQUIRE command.
  • ora-12026 : invalid filter column detected
  • ora-12150 : TNS:unable to send data
  • ora-29877 : failed in the execution of the ODCIINDEXUPDATE routine
  • ora-13150 : failed to insert exception record
  • ora-01633 : Real Application Clusters Option needed for this operation
  • ora-09953 : scggc: unexpected return of a lock convert
  • ora-21607 : memory cartridge service handle not initialized
  • ora-10562 : Error occurred while applying redo to data block (file# string, block# string)
  • ora-12637 : Packet receive failed
  • ora-01659 : unable to allocate MINEXTENTS beyond string in tablespace string
  • ora-14101 : partition extended table name cannot refer to a synonym
  • ora-27140 : attach to post/wait facility failed
  • ora-13333 : invalid LRS measure
  • ora-09875 : TASDEF_WRITE: write error when writing ?/dbs/tasdef@.dbf file.
  • ora-02218 : invalid INITIAL storage option value
  • ora-22626 : Type Mismatch while constructing or accessing OCIAnyData
  • ora-27504 : IPC error creating OSD context
  • ora-12463 : undefined group string for policy string
  • ora-00126 : connection refused; invalid duplicity
  • ora-06034 : NETDNT: connect failed, partner exited unexpectedly
  • ora-27124 : unable to detach from shared memory segment
  • ora-07248 : sfwfb: write error, unable to write database block.
  • ora-13031 : Invalid Gtype in the SDO_GEOMETRY object for point object
  • ora-06130 : NETTCP: host access denied
  • ora-22055 : unknown sign flag value [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.