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-08235: smsget: listener not on this node

1 Answers  


ORA-39103: Timeout before worker process string finished initialization. Worker error:

1 Answers  


KUP-04000: error initializing IO state for file string in string

1 Answers  


ORA-27543: Failed to cancel outstanding IPC request

1 Answers  


ORA-12997: cannot drop primary key column from an index-organized table

1 Answers  






ORA-19035: Invalid select item of the query in newContextFromHierarchy()

1 Answers  


ORA-12482: internal MLS error: string Error: string

1 Answers  


ORA-15173: entry 'string' does not exist in directory 'string'

1 Answers  


QSM-02064: subquery in mv

1 Answers  


ORA-26724: only SYS is allowed to set the Capture or Apply user to SYS.

1 Answers  


DRG-50864: number assignment failed

1 Answers  


ORA-21710: argument is expecting a valid memory address of an object

1 Answers  


Categories