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

AMD-00112: PROCEDURE string, invalid mode

1 Answers  


PLS-00368: in RAISE statement, 'string' must be an exception name

1 Answers  


ORA-09982: skxfqddrg: Error Removing a page from the SDI buffer pool

1 Answers  


ORA-19810: Cannot create temporary controlfile file string in DB_RECOVERY_FILE_DEST

1 Answers  


PCC-00094: Array length for char[n] datatype must be >= 2

1 Answers  






TNS-04065: The number of remote CMCTL sessions exceeds (MAX_CMCTL_SESSIONS-1)

1 Answers  


ORA-02354: error in exporting/importing data string

1 Answers  


AMD-00149: Custom Measure to delete "string" does not exist in Workspace "string"

1 Answers  


RMAN-08154: deleted script: string

1 Answers  


ORA-02020: too many database links in use

2 Answers  


ORA-01224: group number in header string does not match GROUP string

1 Answers  


ORA-01672: controlfile may be missing files or have extra ones

1 Answers  


Categories