ORA-14327: Some index [sub]partitions could not be rebuilt

Cause : Teh ifrts hpaes p(atriito nDLD nadi nedx[ sbu]aprittoinp lcaeemn)t ocmlpeetds uccessflul.y uDrnigt h esceodn hpaes,s oem fo htei nedx[ sbu]aprittoin scuol dnto eb erbiul.t

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


update : 17-08-2017

ORA-14327 - Some index [sub]partitions could not be rebuilt
ORA-14327 - Some index [sub]partitions could not be rebuilt

  • ora-28270 : Malformed user nickname for password authenticated global user.
  • ora-24159 : invalid variable definiton
  • ora-01247 : database recovery through TSPITR of tablespace string
  • ora-29659 : SQLJ Object Type validation failed to get default connection
  • ora-00088 : command cannot be executed by shared server
  • ora-31204 : DBMS_LDAP: PL/SQL - Invalid LDAP Session.
  • ora-24853 : failed to connect thread to shared subsystem
  • ora-13358 : circle type does not contain 3 points
  • ora-31073 : Resource not retrieved using path name
  • ora-28503 : bind value cannot be translated into SQL text for non-Oracle system
  • ora-06526 : Unable to load PL/SQL library
  • ora-25961 : join index prevents dml cascade constraint operation
  • ora-24093 : AQ agent string not granted privileges of database user string
  • ora-37015 : (XSACQUIRE_YNRESYNC) Object workspace object is ambiguously listed to be acquired both with and without RESYNC.
  • ora-12672 : Database logon failure
  • ora-29255 : Cursor contains both bind and define arrays which is not permissible
  • ora-22307 : operation must be on a user-defined type
  • ora-10582 : The control file is not a backup control file
  • ora-07441 : function address must be aligned on string byte boundary
  • ora-13611 : The command string is not a valid advisor command.
  • ora-10933 : trace name context forever
  • ora-07627 : smsfre: $CRETVA failure
  • ora-30384 : specified column name does not exist in the attribute
  • ora-12212 : TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA
  • ora-03210 : DBMS_ADMIN_PACKAGE invalid option specification
  • ora-19680 : some blocks not recovered. See trace file for details
  • ora-00372 : file string cannot be modified at this time
  • ora-25301 : Cannot enqueue or dequeue user buffered messages to a database with version lower than 10.2
  • ora-39050 : parameter string is incompatible with parameter string
  • ora-00361 : cannot remove last log member string for group 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.