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 : 17-08-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-12672 : Database logon failure
  • ora-01792 : maximum number of columns in a table or view is 1000
  • ora-08467 : error converting Oracle number to string
  • ora-26529 : local store callback term phase failed for 'string.string'
  • ora-10922 : Temporary tablespace group is empty
  • ora-12209 : TNS:encountered uninitialized global
  • ora-01165 : MAXDATAFILES may not exceed string
  • ora-25950 : missing where clause in join index specification
  • ora-40105 : input data incompatible with model signature
  • ora-29267 : illegal call
  • ora-06119 : NETTCP: spurious client request
  • ora-39024 : wrong schema specified for job
  • ora-35280 : (SNSYN165) The format of the AGGREGATE command is: AGGREGATE varname1 [varname2 varname3 ...] USING aggmap-name [COUNTVAR intvar-name1 [intvar-name2 intvar-name3 ...]] [FUNCDATA] [THREADS #]
  • ora-12531 : TNS:cannot allocate memory
  • ora-26083 : unsupported direct path stream version string
  • ora-13367 : wrong orientation for interior/exterior rings
  • ora-09788 : sllfrb: unable to read file.
  • ora-26747 : The one-to-many transformation function string encountered the following error: string
  • ora-14167 : only one subpartition may be moved
  • ora-09344 : spsig: error signalling thread
  • ora-06917 : CMX: error in data read (too many bytes read)
  • ora-09772 : osnpmetbrkmsg: message from host had incorrect message type
  • ora-36393 : (XSMXCLEA03) When using the AGGREGATES, CHANGES or CACHE options, you must specify the ALL keyword.
  • ora-39038 : Object path "string" is not supported for string jobs.
  • ora-19650 : Offline-range record recid string stamp string in file string has SCN string
  • ora-01026 : multiple buffers of size > 4000 in the bind list
  • ora-09791 : slembdf: translation error, unable to translate error file name.
  • ora-16120 : dependencies being computed for transaction at SCN string
  • ora-13802 : failed to purge SQL Tuning Base entry from sql$
  • ora-13786 : missing SQL text of statement object "string" for tuning task "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.