Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


QSM-02138: agg(expr) requires correspondng agg(expr*expr)
function



QSM-02138: agg(expr) requires correspondng agg(expr*expr) function..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses certain aggregate functions but omits
an invocation of that same aggregate function on the square
of the same argument.

Action: Add an invocation of the same aggregate function on
the square of the same argument (that is, the argument
multiplied by itself).

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00806: unknown record format specified for data file

1 Answers  


ORA-30770: Cannot specify storage options for fixed size opaque type

1 Answers  


PLS-00222: no function with name 'string' exists in this scope

1 Answers   QuinStreet,


NNL-00303: Server checking for reload

1 Answers  


ORA-00991: only MAC privileges may be granted to procedures

1 Answers  


ORA-14023: creation of GLOBAL partitioned cluster indices is not supported

1 Answers  


ORA-31220: DBMS_LDAP: PL/SQL - Invalid LDAP SSL wallet location.

1 Answers  


TNS-12518: TNS:listener could not hand off client connection

1 Answers  


ORA-16129: unsupported dml encountered

1 Answers  


PCB-00307: DROP TABLE statement is an Oracle extension

1 Answers  


ORA-16761: Resource guard could not stop logical apply engine

1 Answers  


PCC-00010: Statement out of place at line number in file string

1 Answers  


Categories