QSM-02047: window function in mv



QSM-02047: window function in mv..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses a window function.

Action: Re-phrase the query to avoid the use of window
functions.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-22890: cannot specify name for REF column constraint

1 Answers  


ORA-19696: controlfile not found in backup set

1 Answers  


O2F-00310: Illegal or missing identifier name

1 Answers  


ORA-00750: database has been previously mounted and dismounted

2 Answers  


ORA-39124: dump file name "string" contains an invalid substitution variable

1 Answers  






ORA-00314: log string of thread string, expected sequence# string doesn't match string

1 Answers  


ORA-36814: (XSTBLFUNC07) The datatype of the column used in the ROW2CELL clause of a LIMITMAP must be RAW(16).

1 Answers  


DRG-50921: EQUIV operand not a word or another EQUIV expression

1 Answers  


ORA-01344: LogMiner coordinator already attached

1 Answers  


TNS-00020: INTCTL: missing NAVIGATOR_DATA in TNSNAV.ORA

1 Answers  


LPX-00406: object of incorrect type passed to the function

1 Answers  


RMAN-06143: LIKE may only be specified with COPY

1 Answers  


Categories