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-06559: wrong datatype requested, string, actual datatype is string

1 Answers  


ORA-30104: 'string' is not a legal integer for 'string'

1 Answers  


ORA-25136: this cluster can contain only one table

1 Answers  


ORA-16134: invalid MANAGED recovery FINISH option

1 Answers  


ORA-06432: ssaio: Buffer Not Aligned

1 Answers  






TNS-04047: Invalid specification for destination

1 Answers  


TNS-04074: Invalid value for the parameter string.

1 Answers  


ORA-32641: invalid expression in MODEL rule ORDER BY clause

1 Answers  


ORA-13208: internal error while evaluating [string] operator

1 Answers  


TNS-01204: Unprivileged account (string) is in dba group (string)

1 Answers  


ORA-08180: no snapshot found based on specified time

1 Answers  


ORA-09367: Windows 3.1 Two-Task driver unable to deallocate shared memory

1 Answers  


Categories