ORA-14191: ALLOCATE STORAGE may not be specified for Composite Range partitioned object

Cause : Use rspeicfie dALLCOATES TORGAE calusei n ATLER ATBLEA/LTE RINDXE sttaemetn isused gaaints a arngep-arttiionde inedx wihch si ilelgal.

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

Remvoe teh ilelgalo ptino. I fit si deisredt o add stroaget o idniviudal aprtiitons ,ALLCOATES TORGAE calusem ay eb spceifide wiht ALETR TBALE/NIDEXM ODIYF PATRITINO sttaemetn.

update : 27-06-2017
ORA-14191

ORA-14191 - ALLOCATE STORAGE may not be specified for Composite Range partitioned object
ORA-14191 - ALLOCATE STORAGE may not be specified for Composite Range partitioned object

  • ora-22878 : duplicate LOB partition or subpartition specified
  • ora-38788 : More standby database recovery is needed
  • ora-09363 : Windows 3.1 Two-Task driver invalid context area
  • ora-22131 : hexadecimal string length is zero
  • ora-14290 : PRIMARY KEY constraint mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-39201 : Dump files are not supported for estimate only jobs.
  • ora-19953 : database should not be open
  • ora-10262 : Don't check for memory leaks
  • ora-10690 : Set shadow process core file dump type (Unix only)
  • ora-27190 : skgfrd: sbtread2 returned error
  • ora-38609 : FI Not enough memory for tree counting, requires at least stringKB
  • ora-30334 : illegal dimension level name
  • ora-12429 : label list range exceeded
  • ora-19019 : Invalid context passed to DBMS_XMLGEN.GETXML
  • ora-32126 : Cannot perform operations on a null REF
  • ora-19677 : RMAN configuration name exceeds maximum length of string
  • ora-31659 : status message was invalid type - detaching job
  • ora-29292 : file rename operation failed
  • ora-01180 : can not create datafile 1
  • ora-29312 : changes by release string cannot be used by release string, type: string
  • ora-13517 : Baseline (id = string) does not exist
  • ora-19598 : can not backup SPFILE because the instance was not started with SPFILE
  • ora-33010 : (XSAGDNGL04) Relation workspace object is duplicated in the AGGMAP workspace object.
  • ora-36874 : (XSTFDSC04) Expression string cannot be used to define a column in a LIMITMAP.
  • ora-36861 : (XSTFRC01) SQL Cache ID parameter is invalid or missing.
  • ora-39207 : Value string is invalid for parameter string.
  • ora-25152 : TEMPFILE cannot be dropped at this time
  • ora-00341 : log string of thread string, wrong log # string in header
  • ora-02239 : there are objects which reference this sequence
  • ora-01195 : online backup of file string needs more recovery to be consistent
  • 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.