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-19331: Last argument to CREATE_DBURI operator must be a column

1 Answers  


PCC-02047: CMD-LINE: Option is not allowed inline:

1 Answers  


NNL-01045: Errors writing data stream: number

1 Answers  


PLS-01710: In a positioned DELETE or UPDATE statement, the cursor name must be of length 1

1 Answers  


RMAN-06450: crosschecked proxy copy: found to be 'string'

1 Answers  






PCB-00558: Invalid external datatype specified in EXEC SQL VAR statement

1 Answers  


ORA-21600: path expression too long

1 Answers  


RMAN-06065: The backup operand [string] conflicts with another specified operand.

1 Answers  


NID-00504: LOGFILE Output Log (NONE)

1 Answers  


PLS-00662: Non-external object types containing external mapped attributes are not allowed

1 Answers  


ORA-13350: two or more rings of a complex polygon touch

1 Answers  


ORA-00069: cannot acquire lock -- table locks disabled for string

1 Answers  


Categories