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


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-30690: timeout occurred while registering a TCP/IP connection for data traffic detection

1 Answers  


SQL*Loader-00255: Log file for error recovery not used by SQL*Loader

1 Answers  


DRG-11706: invalid relation string

1 Answers  


ORA-23385: replication parallel push string argument not valid

1 Answers  


ORA-12004: REFRESH FAST cannot be used for materialized view "string"."string"

1 Answers  






SQL*Loader-00516: Control file (string) has no contents

1 Answers  


ORA-06775: TLI Driver: error reading break mode

1 Answers  


ORA-16020: less destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST

1 Answers  


ORA-30737: cannot create subtable of a type which is not a subtype of the type of the supertable

1 Answers  


ORA-14644: table is not subpartitioned by Hash method

1 Answers  


PCC-02114: Command line argument MODE=ANSI may not be used with DBMS=V6

1 Answers  


SQL*Loader-00472: collections can contain only one non FILLER field specification

1 Answers  






Categories