QSM-02090: SELECT includes an expression that is not just a
column
- 1 Answers
- 2120 Views
- I also Faced
- E-Mail Answers
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 |
PCC-02430: Expecting an expression of some arbitrary LOB type
ORA-28116: insufficient privileges to do direct path access
ORA-12036: updatable materialized view log is not empty, refresh materialized view
ORA-01615: instance string (thread string) is mounted - cannot disable
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
ORA-33334: (DSSEXIST04) Analytic workspace string is not attached.
ORA-01569: data file too small for system dictionary tables
ORA-25353: branch marked for deletion
SQL*Loader-00655: cannot load object-relational XML attribute using direct path
IMP-00092: Java object "string"."string" already exists, cannot be created
ORA-19701: device name exceeds maximum length of string
ORA-33012: (XSAGDNGL05) AGGMAP workspace object contains invalid syntax.
Oracle Errors 
