ORA-13764: Value "string" is illegal as a result percentage.

Cause : The user attempted to select data from a SQL Tuning Set using an invalid result percentage. The result percentage must be between 0 and 1.

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

Correct the result percentage value and retry the operation.

update : 27-04-2017

ORA-13764 - Value "string" is illegal as a result percentage.
ORA-13764 - Value "string" is illegal as a result percentage.

  • ora-03123 : operation would block
  • ora-12093 : invalid interim table "string"."string"
  • ora-02750 : osnfsmmap: cannot open shared memory file ?/dbs/ftt_.dbf
  • ora-15175 : cannot create alias for diskgroup metadata file 'string'
  • ora-01104 : number of control files (string) does not equal string
  • ora-15182 : ASMLIB [string] version mismatch, ORACLE version [string]
  • ora-02854 : Invalid number of request buffers
  • ora-32762 : Turn on Temp LOB Ref Count Tracing
  • ora-32830 : result code string returned by Messaging Gateway agent
  • ora-29366 : invalid CONSUMER_GROUP argument specified
  • ora-13458 : GeoRaster metadata SRS error
  • ora-12680 : Native services disabled but required
  • ora-30195 : reserved for future use
  • ora-02737 : osnpcl: cannot tell orapop to exit
  • ora-24034 : application string is already a subscriber for queue string
  • ora-19230 : XP0010 - unsupported axis string
  • ora-02459 : Hashkey value must be a positive integer
  • ora-08316 : sllfsk: Error seeking in file.
  • ora-25288 : AQ HTTP propagation encountered error, status-code number, string
  • ora-36179 : (XSNOAGM) No AGGMAP was specified for VARIABLE workspace object.
  • ora-13260 : layer table string does not exist
  • ora-15018 : diskgroup cannot be created
  • ora-25285 : Invalid value string for array_mode
  • ora-02833 : Server was unable to close file
  • ora-38754 : FLASHBACK DATABASE not started; required redo log is not available
  • ora-03236 : max # extents (string) reached in index string.string subpartition string
  • ora-10261 : Limit the size of the PGA heap
  • ora-08446 : syntax error in SYNCHRONIZED clause in mask options
  • ora-14012 : resulting partition name conflicts with that of an existing partition
  • ora-01214 : MAXLOGHISTORY may not exceed 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.