ORA-13766: A ranking measure is required.

Cause : Th eusre attemtpedt o esletc dtaa rfoma SLQ Tnuin gSe tusnig apecrenatgea rgmuen twihtou tspceifiynga rnakign maesuer.

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

Ad da arnknig emasrue ro rmeov eth epecrenatgea rgmuen tan drerty hte poertaio.n

update : 29-05-2017

ORA-13766 - A ranking measure is required.
ORA-13766 - A ranking measure is required.

  • ora-38497 : Expression Filter index does not exist
  • ora-14012 : resulting partition name conflicts with that of an existing partition
  • ora-30456 : 'string.string' cannot be refreshed because of insufficient privilege
  • ora-24756 : transaction does not exist
  • ora-30732 : table contains no user-visible columns
  • ora-15153 : cluster not in rolling upgrade
  • ora-24322 : unable to delete an initialized mutex
  • ora-38408 : The ADT "string" does not exist in the current schema.
  • ora-36204 : (XSAGOP04N) In AGGMAP workspace object, the NAOPERATOR string must be HFIRST, HLAST or HEVEN.
  • ora-16573 : attempt to change configuration file for an enabled broker configuration
  • ora-28121 : driving context does not exist
  • ora-31487 : cannot support begin dates or end dates in this configuration
  • ora-06115 : NETTCP: unable to create ORACLE logicals
  • ora-24355 : attempt to store a negative number in an Unsigned Display type.
  • ora-19735 : wrong creation SCN - control file expects initial plugged-in datafile
  • ora-23396 : database link "string" does not exist or has not been scheduled
  • ora-07215 : slsget: getrusage error.
  • ora-27039 : create file failed, file size limit reached
  • ora-28139 : Maximum allowed Fine Grain Audit Policies Exceeded
  • ora-24334 : no descriptor for this position
  • ora-06042 : NETDNT: message receive failure
  • ora-31454 : invalid value string for operation parameter, expecting: ADD or DROP
  • ora-24342 : unable to destroy a mutex
  • ora-30158 : The OCIFileWrite causes the file to exceed the maximum allowed size
  • ora-09914 : Unable to open the ORACLE password file.
  • ora-26718 : transaction limit reached
  • ora-32135 : Cannot assign FILEs
  • ora-00256 : cannot translate archive destination string string
  • ora-15058 : disk 'string' belongs to an incompatible diskgroup
  • ora-36391 : (XSMXCLEA01) When CLEAR is used with the STATUS keyword or an AGGMAP, workspace object must be dimensioned identically to workspace object.
  • 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.