ORA-14501: object is not partitioned

Cause : Table or index is not partitioned. Invalid syntax.

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

Retry the command with correct syntax.

update : 28-06-2017
ORA-14501

ORA-14501 - object is not partitioned
ORA-14501 - object is not partitioned

  • ora-19371 : invalid update option
  • ora-09769 : osnmbr: cannot send break message
  • ora-22894 : cannot add constraint on existing unscoped REF columns of non-empty tables
  • ora-00386 : use_indirect_data_buffers not supported
  • ora-07823 : sspsqr: $QIO failure
  • ora-30464 : no summaries exist
  • ora-07591 : spdde: $GETJPIW failure
  • ora-33263 : Could not create analytic workspace string
  • ora-06021 : NETASY: connect failed
  • ora-29395 : cannot set the initial consumer group to string
  • ora-02195 : Attempt to create string object in a string tablespace
  • ora-34901 : (PPWKDAYS01) Blank lines are not allowed in the DAYNAMES option.
  • ora-07411 : slgfn: full path name too big for supplied buffer.
  • ora-02084 : database name is missing a component
  • ora-01532 : cannot create database; instance being started elsewhere
  • ora-14076 : submitted alter index partition/subpartition operation is not valid for local partitioned index
  • ora-02770 : Total number of blocks is invalid
  • ora-01128 : cannot start online backup - file string is offline
  • ora-07290 : sksagdi: specified directory for archiving does not exist.
  • ora-30502 : system triggers cannot have INSERT, UPDATE, or DELETE as triggering events
  • ora-31111 : table string cannot be hierarchically enabled
  • ora-02245 : invalid ROLLBACK SEGMENT name
  • ora-32609 : missing REFERENCE keyword in MODEL clause
  • ora-29890 : specified primary operator does not have an index context
  • ora-12445 : cannot change HIDDEN property of column
  • ora-16735 : error executing dbms_logstdby.unskip_error procedure
  • ora-38309 : object not purgable
  • ora-22856 : cannot add columns to object tables
  • ora-13444 : GeoRaster metadata SRS error
  • ora-25274 : AQ Buffered Queue event
  • 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.