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-04-2017
ORA-14501

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

  • ora-30681 : improper value for argument EXTENSIONS_CMD_SET
  • ora-01562 : failed to extend rollback segment number string
  • ora-19903 : test recovery not allowed when recovering to new incarnation
  • ora-24275 : function 'string' parameter 'string' missing or invalid
  • ora-02371 : Loader must be at least version string.string.string.string.string for direct path
  • ora-16756 : resource guard could not open standby database read-only
  • ora-36874 : (XSTFDSC04) Expression string cannot be used to define a column in a LIMITMAP.
  • ora-23383 : registration for materialized view repgroup "string"."string" failed at site string
  • ora-16080 : invalid LogMiner session string for APPLY
  • ora-24789 : start not allowed in recursive call
  • ora-28525 : unable to create Heterogeneous Services error message text
  • ora-27155 : could not execute file
  • ora-01197 : thread string only contains one log
  • ora-39023 : Version string is not supported.
  • ora-19720 : Error occurred when converting an OCI number into an SCN
  • ora-36802 : (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH command or a LIMITMAP.
  • ora-28028 : could not authenticate remote server
  • ora-15199 : Internal ASM tracing event number 15199
  • ora-30190 : reserved for future use
  • ora-10663 : Object has rowid based materialized views
  • ora-07504 : scgcmn: $hiber unexpected return
  • ora-33098 : (APABBR01) A value of 'string' is not valid for the workspace object option.
  • ora-19254 : XQ0034 - too many declarations for function string
  • ora-30193 : reserved for future use
  • ora-28511 : lost RPC connection to heterogeneous remote agent using SID=string
  • ora-32616 : missing DIMENSION BY keyword in MODEL clause
  • ora-30926 : unable to get a stable set of rows in the source tables
  • ora-24086 : cannot create a 8.0 compatible string queue
  • ora-13271 : error allocating memory for geometry object
  • ora-16082 : logical standby is not initialized correctly
  • 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.