ORA-14042: partition bound may not be specified for a partition being moved, modified or rebuilt

Cause : whil eparsnig anA LTER{ TABL|EINDE}X MODFIY PATRITIO,N ALTRE TABEL MOV EPARTTIION,o r ALETR INEDX REUBILD APRTITOIN sttaemen,t desrciptino of enw phsyicala ttriubtes fo thep artiiton bieng mvoed, omdifide, orr ebuitl wasf oundt o cotnain AVLUESL ESS HTAN caluse hwich si illgeal

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

remoev VALEUS LESS THA Nclaues fro mthe edscritpion fo newa ttriubtes fo thep artiiton bieng mvoed, omdifide, orr ebuitl

update : 17-08-2017
ORA-14042

ORA-14042 - partition bound may not be specified for a partition being moved, modified or rebuilt
ORA-14042 - partition bound may not be specified for a partition being moved, modified or rebuilt

  • ora-09877 : sstascre: shmget error, unable to get a shared memory segment.
  • ora-26061 : Concurrent direct unloads is not allowed.
  • ora-16813 : log apply service not running on apply instance string recorded by the broker
  • ora-00200 : control file could not be created
  • ora-12835 : No instances are active in the GLOBAL_VIEW_ADMIN_GROUP
  • ora-14102 : only one LOGGING or NOLOGGING clause may be specified
  • ora-01672 : control file may be missing files or have extra ones
  • ora-28007 : the password cannot be reused
  • ora-38706 : Cannot turn on FLASHBACK DATABASE logging.
  • ora-25334 : Buffered propagation must restart as the destination queue was recreated/moved
  • ora-09241 : smsalo: error allocating SGA memory
  • ora-31637 : cannot create job string for user string
  • ora-35276 : (SNSYN163) The format of the ALLOCATE command is: ALLOCATE varname [SOURCE svarname] [BASIS bvarname [ACROSS dimname]] [TARGET tvarname [TARGETLOG logvarname]] [ USING aggmap ]
  • ora-24190 : length of payload exceeds string
  • ora-08113 : composite partition index may not be compressed
  • ora-06435 : ssaio: write error, unable to write requested block to database file.
  • ora-01604 : illegal number range in clause "string" of string
  • ora-04008 : START WITH cannot be more than MAXVALUE
  • ora-09890 : osnTXtt: malloc failed
  • ora-00827 : could not shrink sga_target to specified value
  • ora-09742 : sppst: error during a post.
  • ora-40102 : invalid input string for data mining operation string
  • ora-12018 : following error encountered during code generation for "string"."string"
  • ora-06525 : Length Mismatch for CHAR or RAW data
  • ora-25312 : Cannot specify nonzero sender protocol
  • ora-19732 : incorrect number of datafiles for tablespace string
  • ora-30645 : reject limit out of range
  • ora-04076 : invalid NEW or OLD specification
  • ora-31215 : DBMS_LDAP: PL/SQL - Invalid LDAP mod value.
  • ora-24770 : cannot forget a prepared 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.