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 : 21-08-2017
ORA-14252

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-03218 : invalid option for CREATE/ALTER TABLESPACE
  • ora-01919 : role 'string' does not exist
  • ora-35074 : (QFHEAD02) EIF file string cannot be read by this version of string.
  • ora-12218 : TNS:unacceptable network configuration data
  • ora-32507 : expecting string but found string
  • ora-03217 : invalid option for alter of TEMPORARY TABLESPACE
  • ora-23441 : object does not exist for refresh group template
  • ora-12597 : TNS:connect descriptor already in use
  • ora-16021 : session string destination cannot be the same as session string destination
  • ora-03277 : invalid SIZE specified
  • ora-30038 : Cannot perform parallel insert on non-partitioned object
  • ora-30501 : instance shutdown triggers cannot have AFTER type
  • ora-36314 : (PHYS01) workspace object must be a dimension, relation or variable.
  • ora-21503 : program terminated by fatal error
  • ora-01718 : BY ACCESS | SESSION clause not allowed for NOAUDIT
  • ora-13201 : invalid parameters supplied in CREATE INDEX statement
  • ora-12725 : unmatched parentheses in regular expression
  • ora-13918 : Updating system alert with reason_id string failed; previous alert not found
  • ora-01649 : operation not allowed with a backup control file
  • ora-06570 : shared pool object does not exist, cannot be pinned
  • ora-30363 : columns in a dimension column list must be in the same relation
  • ora-01324 : cannot add file string due to DB_ID mismatch
  • ora-22819 : scope of input value does not correspond to the scope of the target
  • ora-31077 : invalid attribute "string" specified
  • ora-38721 : Invalid file number.
  • ora-00354 : corrupt redo log block header
  • ora-38407 : The ADT associated with the attribute set already exists.
  • ora-14023 : creation of GLOBAL partitioned cluster indices is not supported
  • ora-28664 : a partitioned table may not be coalesced as a whole
  • ora-25335 : AQ array operations not allowed for buffered messages
  • 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.