QSM-02042: view or subquery in from list



QSM-02042: view or subquery in from list..

Answer / guest

Cause: The capability in question is not supported when the
materialized view references a view or subquery in the FROM
list.

Action: Re-phrase the query to avoid the use of views or
subqueries in in the FROM list.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PCB-00557: USING clause can only be used on a PREPAREd dynamic statement

1 Answers  


ORA-02191: correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT <rbs>

1 Answers  


ORA-12807: process queue could not receive parallel query message

1 Answers  


PCC-02338: structure contains a nested struct or union

1 Answers  


NNL-00912: Alias loops detected: number

1 Answers  






QSM-02144: aggregate functions are present without a GROUP BY clause

1 Answers  


ORA-01212: MAXLOGMEMBERS may not exceed string

1 Answers  


ORA-28274: No ORACLE password attribute corresponding to user nickname exists.

1 Answers  


SQL*Loader-00130: Invalid direct path stream size

1 Answers  


KUP-04074: no write access to directory object string

2 Answers  


PCB-00603: An EXEC TOOLS MESSAGE host variable is not a character type

1 Answers  


ORA-26056: Can not unload from a view through the direct path.

1 Answers  


Categories