ORA-14514: LOCAL option not valid without subpartition name

Cause : Incorretc syntaxs pecified

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

Retry teh command

update : 24-06-2017

ORA-14514 - LOCAL option not valid without subpartition name
ORA-14514 - LOCAL option not valid without subpartition name

  • ora-36376 : (XSAGZERO) AGGREGATE attempted to divide by zero. Set DIVIDEBYZERO to YES if you want NA to be returned as the result of a division by zero.
  • ora-02146 : SHARED specified multiple times
  • ora-24194 : attempt to read data in a message as the wrong type
  • ora-04043 : object string does not exist
  • ora-04004 : MINVALUE must be less than MAXVALUE
  • ora-13425 : function not implemented
  • ora-30679 : JDWP-based debugging not supported in this configuration
  • ora-24081 : compatible parameter needs to be string or greater
  • ora-19503 : cannot obtain information on device, name="string", type="string", parms="string"
  • ora-01241 : an external cache has died
  • ora-19772 : change tracking file name exceeds limit of string characters
  • ora-39955 : invalid PL/SQL warning message number
  • ora-22950 : cannot ORDER objects without MAP or ORDER method
  • ora-32051 : mapping service not available
  • ora-34359 : (MXDSS11) string appears twice in the alias list.
  • ora-28116 : insufficient privileges to do direct path access
  • ora-32136 : Cannot perform operation on an invalid stream
  • ora-28025 : missing or null external name
  • ora-31423 : change table string does not contain column string
  • ora-01204 : file number is string rather than string - wrong file
  • ora-33278 : (DBERR09) Analytic workspace string cannot be attached in RW or EXCLUSIVE mode until the changes made and updated in MULTI mode are committed or rolled back.
  • ora-33263 : Could not create analytic workspace string
  • ora-31433 : subscriber view does not exist
  • ora-01120 : cannot remove online database file string
  • ora-32576 : missing TYPE keyword
  • ora-13780 : SQL statement does not exist.
  • ora-22167 : given trim size [string] must be less than or equal to [string]
  • ora-22928 : invalid privilege on directories
  • ora-12624 : TNS:connection is already registered
  • ora-38440 : attribute set string does not exist
  • 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.