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


QSM-02044: ORDER BY clause in mv



QSM-02044: ORDER BY clause in mv..

Answer / guest

Cause: The capability in question is not supported when the
materialized view includes an ORDER BY clause.

Action: Remove the ORDER BY clause.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-37133: (XSCCOMP08) Cannot write into an aggregated VARIABLE dimensioned by a COMPRESSED COMPOSITE. Use the CLEAR AGGREGATES command to reenable write access.

1 Answers  


ORA-13383: inconsistent network metadata: string

1 Answers  


PLS-00488: invalid variable declaration: object 'string' must be a type or subtype

1 Answers  


ORA-27148: spawn wait error

1 Answers  


ORA-30014: operation only supported in Automatic Undo Management mode

1 Answers  






ORA-12673: Dedicated server: context not saved

1 Answers  


ORA-22874: attribute "string" is not part of the type "string"

1 Answers  


TNS-12564: TNS:connection refused

6 Answers   Oracle,


NNL-00896: Requests refused, modifications disabled: number

1 Answers  


ORA-14102: only one LOGGING or NOLOGGING clause may be specified

1 Answers  


ORA-32126: Cannot perform operations on a null REF

1 Answers  


QSM-02173: the unique constraints does not exist on the join columns of the inner table

1 Answers  






Categories