ORA-16563: unable to add value, syntax error at "string"

Cause : There was an error at the given token.

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

Correct the errors and submit the request again.

update : 29-04-2017
ORA-16563

ORA-16563 - unable to add value, syntax error at "string"
ORA-16563 - unable to add value, syntax error at "string"

  • ora-02231 : missing or invalid option to ALTER DATABASE
  • ora-19665 : size string in file header does not match actual file size of string
  • ora-36863 : (XSTFRC03) The OLAPRC_TABLE function encountered an error while parsing the COLUMNMAP.
  • ora-26660 : Invalid action context value for string
  • ora-14071 : invalid option for an index used to enforce a constraint
  • ora-09931 : Unable to open ORACLE password file for reading
  • ora-24404 : connection pool does not exist
  • ora-30735 : cannot create multiple subtables of the same type under a supertable
  • ora-19241 : XP0021 - cast to type string failed
  • ora-23334 : column string does not exist in table or column group
  • ora-12066 : invalid CREATE MATERIALIZED VIEW command
  • ora-29335 : tablespace 'string' is not read only
  • ora-19805 : recid string of string was deleted to reclaim disk space
  • ora-24755 : OCI_TRANS_NOMIGRATE, OCI_TRANS_JOIN options are not supported
  • ora-31659 : status message was invalid type - detaching job
  • ora-13372 : failure in modifying metadata for a table with spatial index
  • ora-31193 : This versioning feature isn't supported for resource string
  • ora-21525 : attribute number or (collection element at index) string violated its constraints
  • ora-36639 : (XSDUNION18) UNIQUE cannot be applied to this concat dimension because leaves workspace object and workspace object share the value number.
  • ora-26669 : parameter string inconsistent with parameter string
  • ora-16154 : suspect attribute: string
  • ora-36954 : (XSFCAST24) The cycle number must be between 1 and number. You specified number.
  • ora-01672 : control file may be missing files or have extra ones
  • ora-27081 : unable to close the file
  • ora-29314 : tablespace 'string' is not OFFLINE FOR RECOVER nor READ ONLY
  • ora-27302 : failure occurred at: string
  • ora-12902 : default temporary tablespace must be SYSTEM or of TEMPORARY type
  • ora-00705 : inconsistent state during start up; shut down the instance, then restart it
  • ora-12522 : TNS:listener could not find available instance with given INSTANCE_ROLE
  • ora-31645 : unable to read from dump file "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.