ORA-30486: invalid window aggregation group in the window
specification
Answer / guest
Cause: If the window specification is specified using RANGE
option and there are multiple ORDER BY expressions, then the
aggregation group cannot contain any expression (It can only
have CURRENT ROW, UNBOUNDED PRECEDING, or UNBOUNDED
FOLLOWING). First end point (bound) cannot be UNBOUNDED
FOLLOWING and second end point cannot be UNBOUNDED
PRECEDING. If the first end point is CURRENT ROW, then
second end point can only be CURRENT ROW or <expr>
/UNBOUNDED FOLLOWING. If the first end point is <expr>
FOLLOWING, then second end point can only be
<expr>/UNBOUNDED FOLLOWING.
Action: none
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
PLS-00109: unknown exception name 'string' in PRAGMA EXCEPTION_INIT
ORA-01518: CREATE DATABASE must specify more than one log file
TNS-12229: TNS:Interchange has no more free connections
QSM-02180: no primary key constraint in the master table
ORA-29903: error in executing ODCIIndexFetch() routine
PCC-02205: Parser error at line number, column number, file string:
AMD-00137: prefix "string" exceeds maximum permitted length of string characters
TNS-04044: Specified gateways do not exist.
ORA-01688: unable to extend table string.string partition string by string in tablespace string
NNL-00229: Request-processing delay is now disabled
ORA-15073: diskgroup string is mounted by another ASM instance
ORA-04092: cannot string in a trigger