ORA-14081: new partition name must differ from the old partition name

Cause : User entered ALTER TABLE/INDEX RENAME PARTITION specifying which is identical to the name of the partition being renamed

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

Ensure that the new partition name is different from the name of any (including the one being renamed) existing partition of a given table or index

update : 30-04-2017
ORA-14081

ORA-14081 - new partition name must differ from the old partition name
ORA-14081 - new partition name must differ from the old partition name

  • ora-28111 : insufficient privilege to evaluate policy predicate
  • ora-37157 : MDX syntax error was found in MDX query string but error text was missing
  • ora-02462 : Duplicate INDEX option specified
  • ora-23385 : replication parallel push string argument not valid
  • ora-03293 : Cluster to be truncated is a HASH CLUSTER
  • ora-01967 : invalid option for CREATE CONTROLFILE
  • ora-01546 : tablespace contains active rollback segment 'string'
  • ora-08330 : Printing not supported
  • ora-32020 : SID=* clause needed to modify this parameter
  • ora-16094 : database shutdown during archival operation
  • ora-28170 : unsupported certificate version
  • ora-24173 : nested query not supported for rule condition
  • ora-25406 : could not generate a connect address
  • ora-29813 : non-supported object type with associate statement
  • ora-09958 : IMON: two processes with the same ORACLE pid are active
  • ora-00050 : operating system error occurred while obtaining an enqueue
  • ora-29342 : user string does not exist in the database
  • ora-07705 : sksaprs: device name buffer too small
  • ora-30681 : improper value for argument EXTENSIONS_CMD_SET
  • ora-30939 : Order violation: Element 'string' may not follow element 'string'
  • ora-38404 : schema extension not allowed for the attribute set name
  • ora-14174 : only a may follow COALESCE PARTITION|SUBPARTITION
  • ora-12825 : explicit degree of parallelism must be specified here
  • ora-14078 : you may not drop the highest partition of a GLOBAL index
  • ora-13116 : [string]_FACE$ table does not exist
  • ora-30551 : The index depends on a package/type body which does not exist
  • ora-19769 : missing FILE keyword
  • ora-38717 : Invalid DUMP FLASHBACK option.
  • ora-13263 : column string in table string is not of type SDO_GEOMETRY
  • ora-13227 : SDO_LEVEL values for the two index tables do not match
  • 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.