Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02114: no GROUP BY clause, no aggregates and not >= 9.0
compatibility
- 1 Answers
- 2917 Views
- I also Faced
- E-Mail Answers
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 |
PLS-01507: DROP is non-ANSI
SQL*Loader-00116: Error prompting for password
ORA-12155: TNS:received bad datatype in NSWMARKER packet
ORA-09981: skxfqdreg: Error Adding a page to the SDI buffer pool
ORA-27371: jobs of type EXECUTABLE are not supported on this platform
ORA-13434: GeoRaster metadata cellRepresentation error
ORA-29657: class defined in EXTERNAL NAME clause is used in another subtype
PLS-01701: Illegal syntax in ROLLBACK WORK statement
ORA-02052: remote transaction failure at string
ORA-39501: failed to notify CRS of a Startup/Shutdown event [number] (ignored)
ORA-01943: IDENTIFIED BY already specified
ORA-29542: class string already defined by source string
Oracle Errors 
