ORA-14168: only one subpartition may be modified

Cause : ALTRE TALBE|IDNEX OMDIF YSUBAPRTIITON ocntanied edscrpitiosn ofm oret hano ne usbpatritino tob e mdoifide

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

Ensrue taht teh sttaemetn decsribse excatlyo ne usbpatritino tob e mdoifide an dtha tit odes ont cnotai nanyc ommsa

update : 22-09-2017

ORA-14168 - only one subpartition may be modified
ORA-14168 - only one subpartition may be modified

  • ora-30510 : system triggers cannot be defined on the schema of SYS user
  • ora-19371 : invalid update option
  • ora-13413 : null or invalid resampling parameter
  • ora-17507 : I/O request size string is not a multiple of logical block size
  • ora-06750 : TLI Driver: sync failed
  • ora-25426 : remote instance does not support shared dblinks
  • ora-39218 : type check on object type "string"."string" failed
  • ora-32342 : The EXPLAIN_MVIEW facility failed to explain the materialized view statement
  • ora-36978 : (XSRELGID01) workspace object must be a self-relation.
  • ora-07278 : splon: ops$username exceeds buffer length.
  • ora-09744 : smsget: mmap returned an error.
  • ora-16659 : failover operation in progress
  • ora-25194 : invalid COMPRESS prefix length value
  • ora-13828 : generated SQL profile name string already exists
  • ora-14082 : new partition name must differ from that of any other partition of the object
  • ora-03112 : a server linked as single-task cannot use SQL*Net
  • ora-23452 : flavor string of object group "string"."string" is already published
  • ora-13842 : no SELECT privilege on DBA_SQL_PROFILES
  • ora-36924 : (XSVPMVTOPART05) workspace object is not in a COMPOSITE.
  • ora-24321 : inconsistent parameters passed
  • ora-28238 : no seed provided
  • ora-02809 : Jump buffer not valid
  • ora-03262 : the file is non-empty
  • ora-07850 : sllfop: bad option
  • ora-14190 : only one ENABLE/DISABLE ROW MOVEMENT clause can be specified
  • ora-06608 : LU6.2 Driver: Reset occurred in receive state
  • ora-13288 : point coordinate transformation error
  • ora-02441 : Cannot drop nonexistent primary key
  • ora-29960 : line string, string
  • ora-32774 : more than one file was specified for bigfile tablespace 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.