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 : 21-08-2017
ORA-14501

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

  • ora-37076 : (XSMCSESS04) workspace object is not the type of dimension that can have session-only values. Valid types are TEXT, NTEXT, ID, NUMBER, and CONCAT with the UNIQUE attribute.
  • ora-01231 : cannot make read write - file string is offline
  • ora-02029 : missing FILE keyword
  • ora-27378 : cannot stop jobs of type EXECUTABLE on this platform
  • ora-15191 : Internal ASM testing event number 15191
  • ora-06118 : NETTCP: unable to complete handshake with ORASRV
  • ora-01953 : command no longer valid, see ALTER USER
  • ora-12629 : TNS:no event test
  • ora-02880 : smpini: Could not register PGA for protection
  • ora-09847 : soacon: ARCH unable to open named pipe.
  • ora-36280 : (XSCGMDLAGG08) Valueset workspace object does not contain values of any dimension of the current model.
  • ora-28518 : data dictionary translation has illegal translation type
  • ora-15031 : disk specification 'string' matches no disks
  • ora-01598 : rollback segment 'string' is not online
  • ora-12202 : TNS:internal navigation error
  • ora-02210 : no options specified for ALTER TABLE
  • ora-01513 : invalid current time returned by operating system
  • ora-07615 : $CHANGE_CLASS failed in retrieving the specified file label
  • ora-31046 : Incorrect argument(s) specified in the operator
  • ora-04074 : invalid REFERENCING name
  • ora-27001 : unsupported device type
  • ora-04031 : unable to allocate string bytes of shared memory ("string","string","string","string")
  • ora-14082 : new partition name must differ from that of any other partition of the object
  • ora-14097 : column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-37157 : MDX syntax error was found in MDX query string but error text was missing
  • ora-00364 : cannot write header to new log member
  • ora-13243 : specified operator is not supported for 3- or higher-dimensional R-tree
  • ora-25506 : resource manager has not been continuously on in some instances
  • ora-28233 : double encryption not supported
  • ora-06919 : CMX: error during write request (unknown 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.