ORA-14515: only one aubpartition name can be specified

Cause : More than one subpartition name has been specified for analyze

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

Specify one subpartition name.

update : 22-09-2017
ORA-14515

ORA-14515 - only one aubpartition name can be specified
ORA-14515 - only one aubpartition name can be specified

  • ora-01941 : SEQUENCE keyword expected
  • ora-13861 : Statistics aggregation for client identifier string is already enabled
  • ora-22923 : amount of data specified in streaming LOB write is 0
  • ora-02769 : Setting of handler for SIGTERM failed
  • ora-30938 : No prefix defined for namespace 'string' (particle string)
  • ora-28165 : proxy 'string' may not specify password-protected role 'string' for client 'string'
  • ora-36271 : (XSCGMDLAGG11) workspace object is not in the dimension list of valueset workspace object.
  • ora-17613 : Failed to initialize Oracle Disk Manager library: string
  • ora-27467 : invalid datatype for string value
  • ora-12562 : TNS:bad global handle
  • ora-06600 : LU6.2 Driver: SNA software is not loaded
  • ora-24123 : feature string is not yet implemented
  • ora-29832 : cannot drop or replace an indextype with dependent indexes
  • ora-00445 : background process "string" did not start after string seconds
  • ora-36671 : (XSDPART09) Leaves of workspace object have different datatypes. A partition dimension cannot have more than one datatype when RANGE partitioning is used.
  • ora-23463 : flavor incompatible with object "string"."string"
  • ora-32501 : Writing SGA to file failed
  • ora-37177 : column string does not have any leaf values
  • ora-17610 : file 'string' does not exist and no size specified
  • ora-14285 : cannot COALESCE the only partition of this hash partitioned table or index
  • ora-32152 : Cannot perform operation on a null number
  • ora-02230 : invalid ALTER CLUSTER option
  • ora-31634 : job already exists
  • ora-16626 : failed to enable specified object
  • ora-15108 : missing or invalid template name
  • ora-25500 : database is not open
  • ora-22346 : Type has cyclical dependency. Should use CASCADE option
  • ora-36376 : (XSAGZERO) AGGREGATE attempted to divide by zero. Set DIVIDEBYZERO to YES if you want NA to be returned as the result of a division by zero.
  • ora-28333 : column is not encrypted
  • ora-21503 : program terminated by fatal error
  • 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.