Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


QSM-02090: SELECT includes an expression that is not just a
column



QSM-02090: SELECT includes an expression that is not just a column..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses an expression in the select list that
is not a simple column reference.

Action: Re-phrase the query to avoid the use of the
expressions that are not simple column references.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06048: duplicate controlfile specified for restoration from copy

1 Answers  


ORA-13275: spatial index creation failure on unsupported type

1 Answers  


LFI-00134: Unable to protect a file for an append operation.

1 Answers  


ORA-13617: The specified task string already executing

1 Answers  


TNS-04085: Password not changed since last save.

1 Answers  






RMAN-03023: executing command: string

1 Answers  


LPX-00411: unknown function name encountered

1 Answers  


ORA-38764: flashback not started; datafile string enabled threads are different

1 Answers  


ORA-16401: archivelog rejected by RFS

1 Answers  


ORA-14073: bootstrap table or cluster may not be truncated

1 Answers  


ORA-00202: controlfile: 'string'

1 Answers  


IMP-00041: Warning: object created with compilation warnings

1 Answers  






Categories