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-06-2017
ORA-13764

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

  • ora-19254 : XQ0034 - too many declarations for function string
  • ora-22316 : input type is not a collection type
  • ora-16643 : unable to determine location of broker configuration files
  • ora-02448 : constraint does not exist
  • ora-16527 : unable to allocate SGA heap
  • ora-01878 : specified field not found in datetime or interval
  • ora-01285 : error reading file string
  • ora-01262 : Stat failed on a file destination directory
  • ora-28023 : must revoke grants of this role to other user(s) first
  • ora-32827 : Messaging Gateway agent must be shut down
  • ora-31025 : Invalid document element
  • ora-14070 : option may be specified only for partitioned indices or with REBUILD
  • ora-19717 : for non-OMF search the pattern must be specified
  • ora-06554 : package DBMS_STANDARD must be created before using PL/SQL
  • ora-28010 : cannot expire external or global accounts
  • ora-08269 : destroy_ora_addr: cannot destroy name
  • ora-19773 : must specify change tracking file name
  • ora-39216 : object type "string"."string" hashcode mismatch
  • ora-01639 : instance string has no thread assigned to it
  • ora-38487 : FUNCTION/PACKAGE/TYPE "string" not allowed in the expression
  • ora-12684 : encryption/crypto-checksumming: Diffie-Hellman seed too small
  • ora-19241 : XP0021 - cast to type string failed
  • ora-31517 : CDC change table string.string already exists
  • ora-12413 : labels do not belong to the same policy
  • ora-16232 : adding Logical Standby skip entry for table string.string
  • ora-37026 : (XSMLTRESYNC01) Object workspace object cannot be resynced without dimension workspace object.
  • ora-19659 : incremental restore would advance file string past resetlogs
  • ora-15175 : cannot create alias for diskgroup metadata file 'string'
  • ora-13452 : GeoRaster metadata BIN function error
  • ora-10364 : Do not clear GIMH_STC_SHUT_BEGIN state during shutdown
  • 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.