ORA-14252: invalid ALTER TABLE MODIFY PARTITION option for a Hash partition

Cause : nOylA LLCOTA EXEETTNa dnD AELLCOTA ENUSUDEm yab epscefiei dniA TLRET BAELM DOFI YAPTRTIOI Nof r aaHhsp raititno.

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

pScefi ynoyll gelao tpoisn.

update : 28-04-2017

ORA-14252 - invalid ALTER TABLE MODIFY PARTITION option for a Hash partition
ORA-14252 - invalid ALTER TABLE MODIFY PARTITION option for a Hash partition

  • ora-16128 : User initiated stop apply successfully completed
  • ora-15180 : Could not open dynamic library string, error [string]
  • ora-09322 : slpdtb: unable to convert packed decimal to binary
  • ora-06601 : LU6.2 Driver: Invalid database ID string
  • ora-25005 : cannot CREATE INSTEAD OF trigger on a read-only view
  • ora-09915 : Password encryption failed.
  • ora-38706 : Cannot turn on FLASHBACK DATABASE logging.
  • ora-28335 : referenced or referencing FK constraint column cannot be encrypted
  • ora-38468 : column "string" is not identified as a column storing expressions.
  • ora-36690 : (NTEXTCNV01) Error during conversion from NTEXT to TEXT.
  • ora-00323 : Current log of thread string not useable and all others need archiving
  • ora-19500 : device block size string is invalid
  • ora-12547 : TNS:lost contact
  • ora-15018 : diskgroup cannot be created
  • ora-37008 : (AWLISTALL06) number writers
  • ora-23514 : invalid or incorrect number of arguments
  • ora-27152 : attempt to post process failed
  • ora-30203 : Cannot open mesage file
  • ora-31181 : PL/SQL DOM handle accesses node that is no longer available
  • ora-29741 : IMR active for some, but not all members of cluster
  • ora-24345 : A Truncation or null fetch error occurred
  • ora-06704 : TLI Driver: receive break message failed
  • ora-14255 : table is not partitioned by Range, Composite Range or List method
  • ora-22150 : variable-length array has not been initialized
  • ora-28164 : REVOKE already specified
  • ora-38739 : Flashback log file is more recent than control file.
  • ora-30377 : table string.MV_CAPABILITIES_TABLE not found
  • ora-29548 : Java system class reported: string
  • ora-39177 : invalid compression value string
  • ora-31111 : table string cannot be hierarchically enabled
  • 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.