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 : 29-04-2017
ORA-14504

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

  • ora-01917 : user or role 'string' does not exist
  • ora-00080 : invalid global area specified by level string
  • ora-12826 : hung parallel query server was killed
  • ora-12454 : label string does not exist for policy string
  • ora-29859 : error occurred in the execution of ODCIINDEXTRUNCATE routine
  • ora-24121 : both cascade and a block range passed to DBMS_REPAIR.CHECK_OBJECT procedure
  • ora-36312 : (PHYS00) workspace object must be a dimension or dimensioned variable.
  • ora-38959 : Failed to update block 0 to new version 10 format
  • ora-27048 : skgfifi: file header information is invalid
  • ora-31084 : error while creating table "string"."string" for element "string"
  • ora-19801 : initialization parameter DB_RECOVERY_FILE_DEST is not set
  • ora-24439 : success with PLSQL compilation warning
  • ora-16716 : clearing parameter LOG_ARCHIVE_DEST failed
  • ora-00701 : object necessary for warmstarting database cannot be altered
  • ora-13502 : Cannot rename SYSAUX tablespace
  • ora-28529 : invalid or missing parameter in Net8 service name definition
  • ora-16025 : parameter string contains repeated or conflicting attributes
  • ora-01161 : database name string in file header does not match given name of string
  • ora-32816 : foreign queue string is referenced by a subscriber or schedule
  • ora-01955 : DEFAULT ROLE 'string' not granted to user
  • ora-38406 : attribute set string already exists
  • ora-10706 : Print out information about global enqueue manipulation
  • ora-00040 : active time limit exceeded - call aborted
  • ora-14264 : table is not partitioned by Composite Range method
  • ora-36648 : (XSDUNION09) Concat dimension workspace object is already defined as UNIQUE.
  • ora-30101 : unknown parameter name 'string'
  • ora-29342 : user string does not exist in the database
  • ora-14050 : invalid ALTER INDEX MODIFY PARTITION option
  • ora-28650 : Primary index on an IOT cannot be rebuilt
  • ora-19764 : database id string does not match database id string in control file
  • 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.