ORA-14262: new subpartition name must differ from the old subpartition name

Cause : sUree tnredeA TLRET BAELI/DNXER NEMA EUSPBRAITITNOs epicyfni gnhwci hsii edtncilat oht eanemo fht euspbraititnob iegnr nemade

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

nEusert ah tht een wuspbraititnon ma esid fiefertnf or mht eanemo fna yi(cnulidgnt eho enb iegnr nemade )xesiitgns buaptrtioi nfoa g vinet baelo rniedx

update : 21-08-2017
ORA-14262

ORA-14262 - new subpartition name must differ from the old subpartition name
ORA-14262 - new subpartition name must differ from the old subpartition name

  • ora-12525 : TNS:listener has not received client's request in time allowed
  • ora-24124 : invalid ACTION parameter passed to DBMS_REPAIR.string procedure
  • ora-30102 : 'string' is not in the legal range for 'string'
  • ora-24321 : inconsistent parameters passed
  • ora-12319 : database (link name string) is already open
  • ora-01043 : user side memory corruption [string], [string], [string], [string]
  • ora-29813 : non-supported object type with associate statement
  • ora-19669 : proxy copy functions cannot be run on DISK channel
  • ora-24191 : the property name string has existed
  • ora-27008 : function called with invalid file structure
  • ora-38741 : Formatted blocks value string is not valid.
  • ora-08180 : no snapshot found based on specified time
  • ora-07230 : slemcr: fopen error, unable to open error file.
  • ora-07259 : spdcr: exec error, detached process failed in startup.
  • ora-19853 : error preparing auxiliary instance string (error string)
  • ora-25100 : TABLESPACE option can only be used with ALTER INDEX REBUILD
  • ora-24323 : value not allowed
  • ora-31517 : CDC change table string.string already exists
  • ora-22059 : buffer size [string] is too small - [string] is needed
  • ora-23493 : "string" is not a new site for extension request "string"
  • ora-16193 : Primary and standby network encryption mismatch
  • ora-12812 : only one PARALLEL or NOPARALLEL clause may be specified
  • ora-19254 : XQ0034 - too many declarations for function string
  • ora-09342 : Detached process terminated by Oracle during shutdown abort
  • ora-16111 : log mining and apply setting up
  • ora-08260 : ora_addr: cannot open nameserver
  • ora-28545 : error diagnosed by Net8 when connecting to an agent
  • ora-38784 : Cannot create restore point 'string'.
  • ora-31466 : no publications found
  • ora-00261 : log string of thread string is being archived or modified
  • 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.