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 : 24-08-2017
ORA-01415

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

  • ora-22977 : missing or invalid attribute
  • ora-02766 : Invalid maximum of request descriptors
  • ora-04079 : invalid trigger specification
  • ora-19578 : end of volume while duplexing to sequential files, backup piece incomplete
  • ora-16161 : Cannot mix standby and online redo log file members for group string
  • ora-19106 : invalid XQueryX: expected string - got string
  • ora-19683 : real and backup blocksize of file string are unequal
  • ora-12426 : invalid audit option
  • ora-24153 : rule set string.string already exists
  • ora-21522 : attempted to use an invalid connection in OCI (object mode only)
  • ora-28012 : Manual commit not allowed here
  • ora-09885 : osnTXtt: cannot create TXIPC channel
  • ora-01985 : cannot create user as LICENSE_MAX_USERS parameter exceeded
  • ora-31033 : Requested number of XML children string exceeds maximum string
  • ora-31603 : object "string" of type string not found in schema "string"
  • ora-23619 : non-Oracle system error: string
  • ora-32123 : Attribute number is out of range
  • ora-19762 : invalid file type string
  • ora-06009 : NETASY: dialogue filename too long
  • ora-32762 : Turn on Temp LOB Ref Count Tracing
  • ora-30161 : A system error occurred during the OCIFile function call
  • ora-09709 : soacon: failed to accept a connection.
  • ora-14020 : this physical attribute may not be specified for a table partition
  • ora-12690 : Server Authentication failed, login cancelled
  • ora-13224 : zero tolerance specified for layer in USER_SDO_GEOM_METADATA
  • ora-32116 : Buffer size is less than amount specified
  • ora-01679 : database must be mounted EXCLUSIVE and not open to activate
  • ora-09878 : sstascre/sstasat: shmat error, unable to attach tas write page
  • ora-02154 : a tablespace with the name 'string' is found
  • ora-02402 : PLAN_TABLE not found
  • 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.