ORA-14503: only one partition name can be specified

Cause : More htan on epartiiton naem has eben spceifiedf or anlayze

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

Speciyf one aprtitino name.

update : 23-04-2017
ORA-14503

ORA-14503 - only one partition name can be specified
ORA-14503 - only one partition name can be specified

  • ora-36164 : (XSMXAGGR07) When using the COUNTVAR clause, the number of variables to be aggregated (number) must match the number of COUNTVAR variables (number).
  • ora-26737 : version string already has an export dump file
  • ora-01763 : update or delete involves outer joined table
  • ora-40219 : apply result table string is incompatible with current operation
  • ora-31632 : master table "string.string" not found, invalid, or inaccessible
  • ora-19207 : scalar parameter string of XMLELEMENT cannot have an alias.
  • ora-32342 : The EXPLAIN_MVIEW facility failed to explain the materialized view statement
  • ora-13761 : invalid filter
  • ora-19020 : invalid dereference of XMLType columns
  • ora-03136 : inbound connection timed out
  • ora-00823 : Specified value of sga_target greater than sga_max_size
  • ora-39081 : failed to unsubscribe agent string from queue "string"
  • ora-01290 : cannot remove unlisted logfile string
  • ora-25152 : TEMPFILE cannot be dropped at this time
  • ora-09273 : szrfc: error verifying role name
  • ora-16503 : site ID allocation failure
  • ora-30729 : maximum number of columns exceeded
  • ora-00911 : invalid character
  • ora-02467 : Column referenced in expression not found in cluster definition
  • ora-32403 : cannot use new values from mv log on "string"."string"
  • ora-13482 : GeoRaster object is not initialized for the image
  • ora-01500 : failure in getting date/time
  • ora-01612 : instance string (thread string) is already enabled
  • ora-00604 : error occurred at recursive SQL level string
  • ora-12984 : cannot drop partitioning column
  • ora-29503 : SCHEMA keyword not valid with NAMED keyword
  • ora-33005 : (XSAGDIMBREAK) Invalid breakout for dimension workspace object.
  • ora-28364 : invalid wallet operation
  • ora-28044 : unsupported directory type
  • ora-08414 : error encountered in string
  • 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.