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 : 24-07-2017
ORA-14082

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-09808 : Could not obtain user clearance.
  • ora-24124 : invalid ACTION parameter passed to DBMS_REPAIR.string procedure
  • ora-28002 : the password will expire within string days
  • ora-09920 : Unable to get sensitivity label from connection
  • ora-12910 : cannot specify temporary tablespace as default tablespace
  • ora-24337 : statement handle not prepared
  • ora-32017 : failure in updating SPFILE
  • ora-19330 : Type 'string'.'string' not installed. Please install the type before using the CREATE_DBURI operator
  • ora-00828 : specified value of shared_pool_reserved_size inconsistent with internal settings
  • ora-02232 : invalid MOUNT mode
  • ora-26024 : SKIP_UNUSABLE_INDEXES requested and index segment was initially unusable
  • ora-24303 : call not supported in non-deferred linkage
  • ora-12844 : cluster reconfiguration in progress
  • ora-27547 : Unable to query IPC OSD attribute string
  • ora-28142 : error in accessing audit index file
  • ora-08465 : input mask contains more than 32 characters
  • ora-36160 : (XSMXAGGR04) You cannot use string on scalar VARIABLE workspace object.
  • ora-40004 : penalty must be negative for BLAST-N
  • ora-23353 : deferred RPC queue has entries for object group "string"."string"
  • ora-13340 : a point geometry has more than one coordinate
  • ora-38496 : Expression Filter index is not in a valid state
  • ora-24394 : invalid mode for destroying connection pool
  • ora-30753 : column or table string is substitutable
  • ora-16007 : invalid backup control file checkpoint
  • ora-39030 : invalid file type string
  • ora-12622 : TNS:event notifications are not homogeneous
  • ora-06313 : IPA: Shared memory failed to initialise
  • ora-02227 : invalid cluster name
  • ora-08003 : sequence string.NEXTVAL exceeds internal limits
  • ora-00237 : snapshot operation disallowed: control file newly created
  • 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.