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 : 24-06-2017
ORA-14504

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

  • ora-01626 : rollback segment number 'string' cannot handle more transactions
  • ora-02337 : not an object type column
  • ora-01355 : logminer tablespace change in progress
  • ora-01479 : last character in the buffer is not Null
  • ora-14252 : invalid ALTER TABLE MODIFY PARTITION option for a Hash partition
  • ora-19507 : failed to retrieve sequential file, handle="string", parms="string"
  • ora-01664 : Transaction which has expanded the Sort Segment has aborted
  • ora-19694 : some changed blocks were not found in the change tracking file
  • ora-29310 : database is not open, or opened as a clone
  • ora-22603 : cannot add an attribute to the already generated TDS handle
  • ora-30676 : socket read or write failed
  • ora-08276 : No room in nameserver for pid
  • ora-24807 : LOB form mismatch
  • ora-01234 : cannot end backup of file string - file is in use or recovery
  • ora-15027 : active use of diskgroup "string" precludes its dismount
  • ora-22873 : primary key not specified for primary key based object table
  • ora-26701 : STREAMS process string does not exist
  • ora-02203 : INITIAL storage options not allowed
  • ora-28261 : CURRENT_USER can not be used in PLSQL Definer's Right procedure.
  • ora-25222 : enqueue failed, complete sender info. not provided for a queue supporting non-repudiation
  • ora-31696 : unable to export/import string using client specified string method
  • ora-07848 : sllfrb: $GET failure
  • ora-38753 : Cannot flashback data file string; no flashback log data.
  • ora-19598 : can not backup SPFILE because the instance was not started with SPFILE
  • ora-16138 : end of log stream not received from primary
  • ora-01260 : warning: END BACKUP succeeded but some files found not to be in backup mode
  • ora-29545 : badly formed class: string
  • ora-29883 : cannot create a domain index on column expressions
  • ora-01300 : writable database required for specified LogMiner options
  • ora-02298 : cannot validate (string.string) - parent keys not found
  • 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.