ORA-00962: too many group-by / order-by expressions

Cause : The gruop-by o rorder-yb colum nlist cnotain mroe than1 000 exrpession.s

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

Use 1000 or less expressions i nthe gruop-by o rorder-yb list.

update : 23-08-2017

ORA-00962 - too many group-by / order-by expressions
ORA-00962 - too many group-by / order-by expressions

  • ora-23382 : materialized view repgroup "string"."string" is not registered at site string
  • ora-07600 : slkmnm: $GETSYIW failure
  • ora-30507 : normal triggers cannot be based on a schema or a database
  • ora-09740 : slsget: cannot get virtual memory region statistics.
  • ora-16711 : the resource guard index is out of bounds
  • ora-07482 : snlmini: cannot create lock manager instance.
  • ora-29804 : missing DATA keyword
  • ora-12059 : prebuilt table "string"."string" does not exist
  • ora-13454 : GeoRaster metadata is invalid
  • ora-09947 : Unable to allocate connection attributes structure
  • ora-15025 : could not open disk 'string'
  • ora-02161 : invalid value for MAXLOGFILES
  • ora-13787 : missing SQL profile for statement object "string" for tuning task "string"
  • ora-25439 : duplicate variable value for variable: string
  • ora-01563 : rollback segment is PUBLIC, need to use the keyword PUBLIC
  • ora-01508 : cannot create database; error in file 'string' at line string
  • ora-14135 : a LOB column cannot serve as a partitioning column
  • ora-01372 : Insufficient processes for specified LogMiner operation
  • ora-14638 : cannot MERGE subpartitions in different Range Composite partitions
  • ora-14329 : domain index [sub]partitions cannot be renamed in this clause
  • ora-30398 : illegal JOIN KEY clause
  • ora-12664 : Services required by server not available on the client
  • ora-19923 : the session for row with id string is not active
  • ora-10947 : trace name context forever
  • ora-19927 : CONVERT DATABASE operation cannot proceed
  • ora-31004 : Length string of the BLOB in XDB$H_INDEX is below the minimum string
  • ora-39752 : redundant column in partitioning and join columns is not allowed
  • ora-06760 : TLI Driver: timeout reading orderly release
  • ora-38776 : cannot begin flashback generation - flash recovery area is disabled
  • ora-28672 : UPDATE BLOCK REFERENCES may not be used on a global index
  • 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.