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 : 23-08-2017
ORA-16563

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

  • ora-19672 : media management software returned invalid file status
  • ora-19278 : Invalid value: (string) for type: (string)
  • ora-13709 : Required parameter "string" must be set before execution.
  • ora-31058 : cannot modify read-only XOBs
  • ora-34900 : (PPWKDAYS00) At least 7 day names must be given. Only number were provided.
  • ora-12927 : RETENTION option already specified
  • ora-24418 : Cannot open further sessions.
  • ora-15045 : ASM file name 'string' is not in reference form
  • ora-03236 : max # extents (string) reached in index string.string subpartition string
  • ora-12215 : TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA
  • ora-30563 : outer join operator (+) not allowed in select-list
  • ora-29926 : association already defined for the object
  • ora-23376 : node string is not compatible with replication version "string"
  • ora-31669 : Worker process string violated startup protocol.
  • ora-13216 : failed to update spatial index
  • ora-08498 : Warning: picture mask 'string' overrides picture mask option 'USAGE IS string' to 'USAGE IS DISPLAY'
  • ora-02788 : Unable to find kernel process pointer in async process array
  • ora-01256 : error in locking database file string
  • ora-15037 : disk 'string' is smaller than mimimum of string MBs
  • ora-09761 : pw_destroyPorts: server call pws_stop_instance failed.
  • ora-22973 : size of object identifier exceeds maximum size allowed
  • ora-02058 : no prepared transaction found with ID string
  • ora-10842 : Event for OCI Tracing and Statistics Info
  • ora-32143 : Environment not specified
  • ora-29259 : end-of-input reached
  • ora-14080 : partition cannot be split along the specified high bound
  • ora-28100 : policy function schema string is invalid
  • ora-06736 : TLI Driver: server not running
  • ora-00359 : logfile group string does not exist
  • ora-14001 : LOCAL clause contradicts previosly specified GLOBAL clause
  • 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.