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 : 24-07-2017

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

  • ora-30077 : illegal casting between specified datetime types
  • ora-00342 : archived log does not have expected resetlogs SCN string
  • ora-14304 : List partitioning method expects a single partitioning column
  • ora-16639 : specified instance inactive or currently unavailable
  • ora-14001 : LOCAL clause contradicts previosly specified GLOBAL clause
  • ora-37116 : OLAP API table function error: (string)
  • ora-30452 : cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)
  • ora-30011 : Error simulated: psite=string, ptype=string
  • ora-02309 : atomic NULL violation
  • ora-19625 : error identifying file string
  • ora-16593 : XML conversion failed
  • ora-22954 : This multiset operation is not supported for this element type.
  • ora-14134 : indexes cannot use both DESC and REVERSE
  • ora-01571 : redo version string incompatible with ORACLE version string
  • ora-15107 : missing or invalid ASM disk name
  • ora-13443 : GeoRaster metadata SRS error
  • ora-31670 : Username argument must be specified and non-null.
  • ora-02079 : no new sessions may join a committing distributed transaction
  • ora-12805 : parallel query server died unexpectedly
  • ora-02488 : Error encountered when accessing file [string] for trace conversion
  • ora-19646 : cannot change size of datafile string from string to string
  • ora-26008 : Invalid syntax or bind variable in SQL string for column string. string
  • ora-12566 : TNS:protocol error
  • ora-29870 : specified options are only valid for altering a domain index
  • ora-01531 : a database already open by the instance
  • ora-36267 : (XSCGMDLAGG09) workspace object has no dimensions, so it cannot have a qualified data reference.
  • ora-16815 : incorrect redo transport setting for AlternateLocation for standby database "string"
  • ora-02735 : osnfpm: cannot create shared memory segment
  • ora-02170 : FREELIST GROUPS storage option not allowed
  • ora-31669 : Worker process string violated startup protocol.
  • 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.