ORA-14194: only one subpartition may be rebuilt

Cause : ALTER NIDEX REUBILD SUPBARTITINO contanied desrciption sof mor ethan oen subpatrition ot be reubilt

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

Ensuret hat th estatemnet descirbes excatly on esubparittion t obe rebiult andt hat itd oes no tcontai nany commas

update : 27-06-2017
ORA-14194

ORA-14194 - only one subpartition may be rebuilt
ORA-14194 - only one subpartition may be rebuilt

  • ora-24339 : cannot set server group name after connecting to server
  • ora-24436 : Invalid statement Handle.
  • ora-22140 : given size [string] must be in the range of 0 to [string]
  • ora-24006 : cannot create QUEUE, string already exists
  • ora-15128 : ASM file name 'string' exceeds maximum length string
  • ora-30683 : failure establishing connection to debugger
  • ora-28543 : Error initializing apply connection to non-Oracle system
  • ora-22330 : cannot alter a type that is not valid
  • ora-14116 : partition bound of partition "string" is too long
  • ora-02878 : sou2o: Variable smpdidini overwritten
  • ora-12211 : TNS:needs PREFERRED_CMANAGERS entry in TNSNAV.ORA
  • ora-10639 : Dump library cache during kksfbc-reparse-infinite-loop error
  • ora-30020 : UNDO_MANAGEMENT=AUTO needs Compatibility string or greater
  • ora-06959 : Buffer I/O quota is too small
  • ora-23469 : %s is different between templates
  • ora-10645 : Recursive Extension in SYSTEM tablespace during migration
  • ora-14311 : Expecting VALUES LESS THAN or AT clause
  • ora-06908 : CMX: error during transfer of ORACLE_SID
  • ora-34141 : (MXCGPUT00) You cannot use the ASSIGN keyword with DIMENSION workspace object.
  • ora-01248 : file string was created in the future of incomplete recovery
  • ora-28670 : mapping table cannot be dropped due to an existing bitmap index
  • ora-09888 : osnTXtt: txipc channel creation failed
  • ora-29661 : Unable to find the superclass of the defined in the EXTERNAL NAME
  • ora-13364 : layer dimensionality does not match geometry dimensions
  • ora-25250 : Cannot specify a remote recipient for the message
  • ora-32761 : Turn off Temp LOB Ref Count Feature
  • ora-13623 : The recommendation string is not valid for task string.
  • ora-01648 : log string is the current log of disabled instance string (thread string)
  • ora-29250 : Invalid index specifed in call to dbms_sql.bind_array
  • ora-14159 : duplicate subpartition name
  • 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.