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 : 22-06-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-38716 : Must supply an integer for the TYPE option.
  • ora-12637 : Packet receive failed
  • ora-12634 : Memory allocation failed
  • ora-06548 : no more rows needed
  • ora-01936 : cannot specify owner when creating users or roles
  • ora-13437 : GeoRaster metadata blocking error
  • ora-29957 : cannot create a function-based domain index on a string table
  • ora-23443 : missing template parameter
  • ora-31670 : Username argument must be specified and non-null.
  • ora-06108 : NETTCP: connect to host failed
  • ora-25201 : invalid value, VISIBILITY should be ON_COMMIT or IMMEDIATE
  • ora-16784 : the database name in Dependency property is incorrect
  • ora-22950 : cannot ORDER objects without MAP or ORDER method
  • ora-14151 : invalid table partitioning method
  • ora-13859 : Action cannot be specified without the module specification
  • ora-24778 : cannot open connections
  • ora-29309 : export dump file was generated by different version of DBMS_PITR package
  • ora-12039 : unable to use local rollback segment "string"
  • ora-30346 : hierarchy name must be unique within a dimension
  • ora-02324 : more than one column in the SELECT list of THE subquery
  • ora-06257 : NETNTT: cannot send command line to shadow process
  • ora-31003 : Parent string already contains child entry string
  • ora-12053 : this is not a valid nested materialized view
  • ora-27207 : syntax error in device PARMS - parentheses mismatch or missing
  • ora-29511 : could not resolve Java class
  • ora-06570 : shared pool object does not exist, cannot be pinned
  • ora-02329 : column of datatype string cannot be unique or a primary key
  • ora-28109 : the number of related policies has exceeded the limit of 16
  • ora-30101 : unknown parameter name 'string'
  • ora-07211 : slgcs: gettimeofday error, unable to get wall clock.
  • 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.