ORA-14504: syntax not supported for analyze

Cause : A partition/subpartition number or bind variable has been used

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

Specify a valid partition/subpartition name.

update : 19-08-2017
ORA-14504

ORA-14504 - syntax not supported for analyze
ORA-14504 - syntax not supported for analyze

  • ora-25178 : duplicate PCTTHRESHOLD storage option specification
  • ora-31121 : The string operator can not be FALSE
  • ora-01337 : log file has a different compatibility version
  • ora-10265 : Keep random system generated output out of error messages
  • ora-30739 : cannot drop a table that has subtables
  • ora-28113 : policy predicate has error
  • ora-16178 : Cannot specify remote destinations in archivelog manual mode
  • ora-22627 : tc [string] must be that of object/varray/nested table
  • ora-02444 : Cannot resolve referenced object in referential constraints
  • ora-09945 : Unable to initialize the audit trail file
  • ora-14272 : only a partition with higher bound can be reused
  • ora-01299 : dictionary string corresponds to a different database incarnation
  • ora-12070 : cannot offline instantiate materialized view "string"."string"
  • ora-37041 : (XSACQUIRE_DEP_TIMEOUT) Composite, concat, dimension map, or internal partition workspace object is locked by another user and the WAIT timed out.
  • ora-26761 : Standby Redo Logs not available for real time mining
  • ora-24099 : operation not allowed for 8.0 compatible queues
  • ora-32314 : REFRESH FAST of "string"."string" unsupported after deletes/updates
  • ora-38461 : XML Tag "string" already exists for the XMLType attribute "string"
  • ora-13863 : Statistics aggregation for service(module/action) string is not enabled
  • ora-29553 : class in use: string.string
  • ora-29517 : recursive resolution failed for a referenced class
  • ora-02824 : Request free list is empty
  • ora-24141 : rule set string.string does not exist
  • ora-39166 : Object string was not found.
  • ora-25455 : evaluation error for rule set: string.string, evaluation context: string.string
  • ora-30934 : 'string' (string node) cannot be inserted in parent 'string' (string node)
  • ora-14031 : partitioning column may not be of type LONG or LONG RAW
  • ora-26726 : logical standby and DOWNSTREAM_REAL_TIME_MINE are incompatible
  • ora-30399 : a skip level must have at least one column that allows NULL values
  • ora-39127 : unexpected error from call to string 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.