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 : 29-04-2017
ORA-00962

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

  • ora-38717 : Invalid DUMP FLASHBACK option.
  • ora-33298 : (AWUPG01) Analytic Workspace string is already in the newest format allowed by the current compatibility setting
  • ora-04006 : START WITH cannot be less than MINVALUE
  • ora-01704 : string literal too long
  • ora-09740 : slsget: cannot get virtual memory region statistics.
  • ora-23472 : materialized view "string"."string" must be atomically refreshed
  • ora-01929 : no privileges to GRANT
  • ora-16015 : log string sequence# string not archived, media recovery disabled
  • ora-30055 : NULL snapshot expression not allowed here
  • ora-12224 : TNS:no listener
  • ora-02805 : Unable to set handler for SIGTPA
  • ora-03263 : cannot drop the first file of tablespace string
  • ora-16143 : RFS connections not allowed during or after terminal recovery
  • ora-01038 : cannot write database file version string with ORACLE version string
  • ora-19592 : wrong string conversation type
  • ora-01211 : Oracle7 data file is not from migration to Oracle8
  • ora-02070 : database stringstring does not support string in this context
  • ora-25257 : consumer must be specified with a multi-consumer queue
  • ora-16192 : Primary and standby network integrity mismatch
  • ora-32606 : missing NAV keyword in MODEL clause
  • ora-14607 : Tablespace was not specified for previous subpartitions in template but is specified for string
  • ora-30687 : session terminated by debugger
  • ora-36167 : (XSAGGRFORM) workspace object is an illegal AGGMAP for aggregating a FORMULA.
  • ora-07216 : slghst: gethostname error, unable to get name of current host.
  • ora-13294 : cannot transform geometry containing circular arcs
  • ora-14516 : subpartition corrupt. all rows do not fall within subpartition bounds
  • ora-14084 : you may specify TABLESPACE DEFAULT only for a LOCAL index
  • ora-00263 : there are no logs that need archiving for thread string
  • ora-36400 : (XSSPROP02) workspace object is not a valid variable name.
  • ora-25528 : too many candidate MTTRs are specified in _DB_MTTR_SIM_TARGET
  • 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.