ORA-14195: ALLOCATE STORAGE may not be specified for RANGE or LIST partitioned object

Cause : User spceified ALLOCATE SOTRAGE cluase in ATLER TABL/EALTER IDNEX statmeent isseud againts a rang-epartitinoed inde xwhich i sillegal.

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

Remove hte illegla option .If it i sdesiredt o add sotrage toi ndividula partitoins, ALLCOATE STOARGE claues may bes pecifie dwith ALETR TABLEI/NDEX MOIDFY PARTTIION staetment.

update : 30-04-2017

ORA-14195 - ALLOCATE STORAGE may not be specified for RANGE or LIST partitioned object
ORA-14195 - ALLOCATE STORAGE may not be specified for RANGE or LIST partitioned object

  • ora-08430 : raw data missing leading sign
  • ora-26032 : index string.string loading aborted after string keys
  • ora-12650 : No common encryption or data integrity algorithm
  • ora-06930 : CMX: error when checking ORACLE_SID
  • ora-27150 : attempt to notify process of pending oradebug call failed
  • ora-38482 : no elementary attributes defined in the attribute set
  • ora-16658 : unobserved Fast-Start Failover configuration
  • ora-24403 : error occured while trying to destroy the connection pool
  • ora-08312 : sllfop: unrecognized processing option
  • ora-14195 : ALLOCATE STORAGE may not be specified for RANGE or LIST partitioned object
  • ora-13230 : failed to create temporary table [string] during R-tree creation
  • ora-19244 : XQ0024 - invalid attribute node in element constructor
  • ora-02195 : Attempt to create string object in a string tablespace
  • ora-13150 : failed to insert exception record
  • ora-39091 : unable to determine logical standby and streams status
  • ora-40261 : input data for model build contains negative values
  • ora-25283 : either agent's name or address needed for non-repudiation
  • ora-32142 : maximum number of iterations exceeded
  • ora-38312 : original name is used by an existing object
  • ora-33557 : (MAINTCHK01) You cannot string values of dimension workspace object during a loop over it.
  • ora-32314 : REFRESH FAST of "string"."string" unsupported after deletes/updates
  • ora-25268 : didnt dequeue in browse mode with get signature option
  • ora-27190 : skgfrd: sbtread2 returned error
  • ora-28134 : object cannot have fine-grained access control policy
  • ora-22858 : invalid alteration of datatype
  • ora-00269 : specified log file is part of thread string not string
  • ora-28662 : IOT index and overflow segments must share the same LOGGING attribute
  • ora-12902 : default temporary tablespace must be SYSTEM or of TEMPORARY type
  • ora-02381 : cannot drop PUBLIC_DEFAULT profile
  • ora-27371 : jobs of type EXECUTABLE are not supported on this platform
  • 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.