ORA-01415: too many distinct aggregate functions

Cause : Theq uer yconatinsm ored istnict gagreagtest hanc an eb prcoessde. Teh currentl imi tis 525.

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

Redcue teh nubmer fo ditsinc taggergat efuntcion sin hte qeury.

update : 29-06-2017
ORA-01415

ORA-01415 - too many distinct aggregate functions
ORA-01415 - too many distinct aggregate functions

  • ora-12523 : TNS:listener could not find instance appropriate for the client connection
  • ora-06978 : X.25 Driver: Too many callback tries
  • ora-38782 : cannot flashback database to non-guaranteed restore point 'string'
  • ora-09201 : sfcopy: error copying file
  • ora-16510 : messaging error using ksrwait
  • ora-03291 : Invalid truncate option - missing STORAGE keyword
  • ora-10947 : trace name context forever
  • ora-08342 : sropen: failed to open a redo server connection
  • ora-32629 : measure used for referencing cannot be updated
  • ora-31466 : no publications found
  • ora-01146 : cannot start online backup - file string is already in backup
  • ora-39092 : unable to set SCN metadata for object "string.string" of type string
  • ora-32820 : subscriber queue and exception queue must use same message system link
  • ora-07706 : error in archive text: need disk file name
  • ora-16212 : number processes specified for APPLY is too great
  • ora-10665 : Inject Evil Literals
  • ora-26027 : unique index string.string partition string initially in unusable state
  • ora-29330 : Source script length too big
  • ora-29356 : These parameters can be specified only for directives that refer to consumer groups
  • ora-01102 : cannot mount database in EXCLUSIVE mode
  • ora-16108 : database is no longer a standby database
  • ora-13444 : GeoRaster metadata SRS error
  • ora-09211 : sfwfb: error writing to file
  • ora-21300 : objects option not installed
  • ora-32139 : Cannot write to the stream
  • ora-39201 : Dump files are not supported for estimate only jobs.
  • ora-33215 : (CINSERT07) You cannot add session-only values to the workspace object dimension.
  • ora-30161 : A system error occurred during the OCIFile function call
  • ora-32127 : REFs do not belong to any connection
  • ora-36410 : (VCACHE03) 'number' is an invalid value for the $VARCACHE property. The only permissible values are 'DEFAULT', 'SESSION', 'VARIABLE', and 'NONE'.
  • 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.