ORA-30486: invalid window aggregation group in the window
specification
- 1 Answers
- 2963 Views
- I also Faced
- E-Mail Answers
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-06959: Buffer I/O quota is too small
ORA-27004: invalid blocksize specified
ORA-13456: GeoRaster cell data error
IMG-00814: fail queue free failed
PLS-00363: expression 'string' cannot be used as an assignment target
ORA-29540: class string does not exist
NNL-00809: Queries received, multiple types: number
ORA-16165: LGWR failed to hear from network server
RMAN-06471: no configuration found to allocate channels for string
ORA-27122: unable to protect memory
PLS-00380: functions and procedures are not included in this release of PL/SQL
ORA-01920: user name 'string' conflicts with another user or role name
Oracle Errors 
