QSM-02114: no GROUP BY clause, no aggregates and not >= 9.0
Answer / guest
Cause: The capability in question is not supported when the
materialized view has no GROUP BY clause, no aggregates and
compatibility mode is less than 9.0.
Action: Re-phrase the query to avoid the include a GROUP BY
clause or an aggregate function. Or set compatibility mode
to 9.0 or greater.
Please add more information about this Error
|Is This Answer Correct ?||0 Yes||0 No|
ORA-39000: bad dump file specification
KUP-04000: error initializing IO state for file string in string
ORA-31434: purge is currently running
ORA-01303: subordinate process error: number. Check alert and trace logs
ORA-00279: change string generated at string needed for thread string
ORA-01613: instance string (thread string) only has string logs - at least 2 logs required to enable.
TNS-01057: Program name: string
In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.
ORA-01240: too many data files to add in one command
DRG-11111: value of string must be between string and string
ORA-09959: IMON: deletion of a process failed.
ORA-30567: name already used by an existing log group