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

ORA-24097: Invalid value string, string should be non-negative

1 Answers  


ORA-07645: sszfsl: $CHANGE_CLASS failure

1 Answers  


ORA-28011: the account will expire soon; change your password now

1 Answers  


ORA-00020: maximum number of processes (string) exceeded

2 Answers  


PCC-02351: illegal datatype equivalencing operation

1 Answers  






ORA-01267: Failure getting date/time

1 Answers  


ORA-27507: IPC error disconnecting from a port

1 Answers  


ORA-13011: value is out of range

1 Answers  


ORA-07715: sksadtd: could not dismount archival device (SYS$DISMNT failure)

1 Answers  


ORA-22065: number to text translation for the given format causes overflow

1 Answers  


ORA-34871: (PERMIT06) Session-only value 'value' of workspace object has been deleted because a PERMIT change has revealed a duplicate value.

1 Answers  


NCR-02006: NCRF: Invalid floating point representation received

1 Answers  


Categories