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

TNS-04045: Invalid specification of time

1 Answers  


ORA-15002: parameter LOCK_NAME_SPACE exceeds limit of string characters

1 Answers  


ORA-01031: insufficient privileges

1 Answers  


ORA-25187: specified exceptions table form incorrect

1 Answers  


QSM-01093: anti-join marker not found in materialized join view

1 Answers  






PCC-02013: unknown escape sequence

1 Answers  


ORA-02754: osnfsmmap: cannot change shared memory inheritence

1 Answers  


DGM-16959: NULL answer from DMON

1 Answers  


ORA-31625: error changing username from string to string

1 Answers  


ORA-32766: instr with negative offset: use varchar semantics on LOBs

1 Answers  


PCC-02430: Expecting an expression of some arbitrary LOB type

1 Answers  


ORA-36670: (XSDPART08) workspace object is an INTEGER or NTEXT dimension, or contains an INTEGER or NTEXT dimension. INTEGER and NTEXT dimensions cannot be used as partition dimensions.

1 Answers  


Categories