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

ORA-03126: network driver does not support non-blocking operations

1 Answers  


ORA-39123: Data Pump transportable tablespace job aborted string

1 Answers  


ORA-19767: missing TRACKING keyword

1 Answers  


RMAN-06495: must explicitly specify DBID with SET DBID command

1 Answers  


RMAN-06548: connected to auxiliary database: string (DBID=string)

1 Answers  






ORA-38428: too many attributes selected for indexing

1 Answers  


DRG-12201: section group string already exists

1 Answers  


ORA-06577: output parameter not a bind variable

1 Answers  


SQL*Loader-00524: partial record found at end of datafile (string)

1 Answers  


NID-00301: Datafile string - dbid changed, wrote new name

1 Answers  


PCC-02105: Unable to open list file

1 Answers  


PLS-01907: : number precision too large

1 Answers  


Categories