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 |
TNS-01108: Listener password prompt failed
O2I-00129: No Java file specified
LCD-00203: missing keyword [string]
ORA-02225: only EXECUTE and DEBUG privileges are valid for procedures
ORA-16625: cannot reach the primary
PLS-00728: the limit of a VARRAY can only be increased and to a maximum 2147483647
IMG-00003: exhausted memory while processing image
ORA-24049: invalid agent name string, names with AQ$_ prefix are not valid
ORA-12551: TNS:missing keyword
DRG-11856: FTP Server Doesn't Reply
ORA-38730: Invalid SCN/TIMESTAMP expression.
ORA-04082: NEW or OLD references not allowed in table level triggers