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 : 25-09-2017

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

  • ora-25292 : Buffer operations are not supported on the queue
  • ora-01633 : Real Application Clusters Option needed for this operation
  • ora-02174 : Missing required thread number
  • ora-01577 : cannot add log file 'string' - file already part of database
  • ora-29533 : attempt to overwrite class or resource string while defining or compiling string.string
  • ora-13368 : simple polygon type has more than one exterior ring
  • ora-06571 : Function string does not guarantee not to update database
  • ora-28507 : error in data dictionary view string
  • ora-16659 : failover operation in progress
  • ora-01563 : rollback segment is PUBLIC, need to use the keyword PUBLIC
  • ora-29307 : datafile string error, string
  • ora-31117 : Table "string"."string" is not resource metadata enabled
  • ora-29907 : found duplicate labels in primary invocations
  • ora-00201 : control file version string incompatible with ORACLE version string
  • ora-23487 : object groups "string"."string" and "string"."string" do not have the same connection qualifier
  • ora-01251 : Unknown File Header Version read for file number string
  • ora-19624 : operation failed, retry possible
  • ora-14003 : GLOBAL clause contradicts previosly specified LOCAL clause
  • ora-36634 : (XSDUNION02) INTEGER dimension workspace object cannot be used as a concat dimension base.
  • ora-29291 : file remove operation failed
  • ora-31492 : could not set session parameters for LogMiner session
  • ora-01114 : IO error writing block to file string (block # string)
  • ora-38494 : column in the table alias and an attribute have matching names
  • ora-02307 : cannot alter with REPLACE option a type that is not valid
  • ora-30065 : test support for row dependencies
  • ora-31487 : cannot support begin dates or end dates in this configuration
  • ora-12057 : materialized view "string"."string" is INVALID and must complete refresh
  • ora-33288 : (DBERR15) Another user has incompatible access to analytic workspace string, and the wait timeout has expired.
  • ora-31225 : DBMS_LDAP: invalid BER_ELEMENT
  • ora-30433 : 'string.string' is not a summary
  • 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.