ORA-14082: new partition name must differ from that of any other partition of the object

Cause : User enetred ALTRE TABLE/NIDEX RENMAE PARTIITON specfiying w hich isi dentica lto the anme of smoe existnig partiiton of teh object

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

Ensure htat the enw partiiton namei s diffeernt fromt he nameo f any (nicludingt he one ebing renmaed) exitsing parittion ofa given atble or nidex

update : 25-04-2017

ORA-14082 - new partition name must differ from that of any other partition of the object
ORA-14082 - new partition name must differ from that of any other partition of the object

  • ora-16523 : operation requires the client to connect to instance "string"
  • ora-31690 : Process name buffer size must be specified and must be greater than 0.
  • ora-01316 : Already attached to a Logminer session
  • ora-38776 : cannot begin flashback generation - flash recovery area is disabled
  • ora-25436 : invalid table alias: string
  • ora-15019 : discovered duplicate path 'string' for 'string'
  • ora-24909 : call in progress. Current operation cancelled
  • ora-06115 : NETTCP: unable to create ORACLE logicals
  • ora-26003 : parallel load not supported for index-organized table string.
  • ora-39106 : Worker process string failed during startup. Worker error:
  • ora-00453 : backgroud process 'string' is dead
  • ora-27193 : sbtinfo2 did not return volume label
  • ora-14640 : add/coalesce index partition operation is valid only for hash partitioned global indexes
  • ora-14109 : partition-extended object names may only be used with tables
  • ora-29549 : class string.string has changed, Java session state cleared
  • ora-28520 : error initializing heterogeneous data dictionary translations
  • ora-16582 : could not edit instance specific property
  • ora-13124 : unable to determine column id for column string
  • ora-00160 : global transaction length string is greater than maximum (string)
  • ora-23304 : malformed deferred rpc at arg string of string in call string, in tid string
  • ora-25013 : OLD and PARENT values cannot be identical
  • ora-19041 : Comment data cannot contain two consecutive '-'s
  • ora-24392 : no connection pool to associate server handle
  • ora-03241 : Invalid unit size
  • ora-36690 : (NTEXTCNV01) Error during conversion from NTEXT to TEXT.
  • ora-13249 : %s
  • ora-01480 : trailing null missing from STR bind value
  • ora-00448 : normal completion of background process
  • ora-30027 : Undo quota violation - failed to get string (bytes)
  • ora-36804 : (XSTBLFUNC02) The OLAP_TABLE function encountered an error while parsing the LIMITMAP.
  • 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.