QSM-02057: ROWNUM referenced in mv



QSM-02057: ROWNUM referenced in mv..

Answer / guest

Cause: The capability in question is not supported when the
materialized view references the ROWNUM function.

Action: Re-phrase the query to avoid the use of the ROWNUM
function.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-00125: Failed to get number of Interchanges in TNSNET.ORA

1 Answers  


QSM-00780: the task string could not be executed because the workload string is being modified

1 Answers  


IMG-00720: image processing internal error

1 Answers  


DRG-11129: the rule table is empty

1 Answers  


ORA-39061: import mode string conflicts with export mode string

1 Answers  






NZE-28838: no identity descriptor

1 Answers  


ORA-36883: (XSSRF02) The first parameter of an AW single row function cannot be NULL.

1 Answers  


ORA-28654: table and partition not overflow compatible

1 Answers  


ORA-02420: missing schema authorization clause

1 Answers  


NNO-00307: invalid server name "string"

1 Answers  


ORA-01181: file string created before last known RESETLOGS, cannot recreate

1 Answers  


ORA-06312: IPA: Incorrect outgoing service name supplied

1 Answers  


Categories