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 |
ORA-19904: test recovery not allowed for datafile string
KUP-04004: error while reading file string
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
ORA-27502: IPC error deleting OSD context
ORA-06111: NETTCP: disconnect failure
ORA-25192: invalid option for an index-organized table
ORA-07591: spdde: $GETJPIW failure
ORA-06533: Subscript beyond count
ORA-01903: EVENTS keyword expected
ORA-01144: File size (string blocks) exceeds maximum of string blocks
ORA-15040: diskgroup is incomplete
ORA-01298: conflicting dictionary option