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 : 27-06-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-06423 : NETCMN: Error in receiving data
  • ora-02356 : The database is out of space. The load cannot continue
  • ora-33012 : (XSAGDNGL05) AGGMAP workspace object contains invalid syntax.
  • ora-28338 : cannot encrypt indexed column(s) with salt
  • ora-14031 : partitioning column may not be of type LONG or LONG RAW
  • ora-09967 : unable to create or open lock file
  • ora-13623 : The recommendation string is not valid for task string.
  • ora-10852 : Enable tracing for Enqueue Dequeue Operations
  • ora-10262 : Don't check for memory leaks
  • ora-22618 : attribute is a BAD NULL in the image handle
  • ora-30129 : invalid function argument received
  • ora-12215 : TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA
  • ora-30029 : no active undo tablespace assigned to instance
  • ora-38439 : invalid operation "string"
  • ora-16067 : activation identifier mismatch in archive log string
  • ora-07409 : slpdtb: invalid packed decimal nibble.
  • ora-12901 : default temporary tablespace must be of TEMPORARY type
  • ora-23426 : deferred RPC queue has entries for string
  • ora-33046 : (XSAGDNGL22) In AGGMAP workspace object, you can specify only one SCREENBY clause.
  • ora-19632 : file name not found in control file
  • ora-12811 : PARALLEL_MIN_SERVERS must be less than or equal to PARALLEL_MAX_SERVERS, string
  • ora-15169 : destination 'string' is a subdirectory of 'string'
  • ora-31064 : Cannot instantiate abstract element or property [string]
  • ora-29962 : fatal error occurred in the execution of ODCIINDEXALTER routine
  • ora-02009 : the size specified for a file must not be zero
  • ora-28525 : unable to create Heterogeneous Services error message text
  • ora-39501 : failed to notify CRS of a Startup/Shutdown event [string] (ignored)
  • ora-01253 : cannot start online backup - file string in recovery manager backup
  • ora-01858 : a non-numeric character was found where a numeric was expected
  • ora-01456 : may not perform insert/delete/update operation inside a READ ONLY transaction
  • 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.