QSM-02056: correlated variable and outer join in mv



QSM-02056: correlated variable and outer join in mv..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses a correlated variable and an outer join.

Action: Re-phrase the query to avoid the use of the
correlated variables or outer joins.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-12502: cannot modify stoplists owned by other users

1 Answers  


ORA-09933: Deletion of old password file failed.

1 Answers  


ORA-24366: migratable user handle is set in service handle

1 Answers  


ORA-30438: unable to access named pipe 'string'

1 Answers  


ORA-30349: specified dimension hierarchy does not exist

1 Answers  






ORA-24909: call in progress. Current operation cancelled

1 Answers  


O2F-00314: AS expected but not seen in the INTYPE file

1 Answers  


ORA-16584: illegal operation on a standby site

1 Answers  


SQL*Loader-00710: Internal error: direct path stream buffer not loaded

1 Answers  


ORA-13602: The specified parameter string is not valid for task or object string.

1 Answers  


ORA-19200: Invalid column specification

1 Answers  


ORA-29844: duplicate operator name specified

1 Answers  


Categories