Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


QSM-02139: agg(expr) requires correspondng agg(expr+expr)
function



QSM-02139: 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 same
argument added to the same argument.

Action: Add the indicated aggregate function to the select list.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-08052: cataloged controlfile copy

1 Answers  


TNS-00208: Logging : string

1 Answers  


ORA-30691: failed to allocate system resources while registering a TCP/IP connection for data traffic detection

1 Answers  


RMAN-03028: fatal error code for command string : number

1 Answers  


RMAN-08587: input is copy of datafile string: string

1 Answers  






ORA-14306: List value 'string' specified twice in partitions 'string', 'string'

1 Answers  


ORA-22307: operation must be on a user-defined type

1 Answers  


RMAN-06582: AS COPY option cannot be used when backing up backupsets

1 Answers  


DRG-12012: Proxy authentication failed - retry?

1 Answers  


PROT-00004: Failed to retrieve data from the cluster registry

1 Answers  


PCC-00007: Invalid WHENEVER condition at column number in line number of file string

1 Answers  


ORA-01609: log string is the current log for thread string - cannot drop members

1 Answers  






Categories