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-27461: The value for attribute string is too large.
ORA-06518: PL/SQL: Probe version string incompatible with version string
RMAN-06193: connected to target database (not started)
ORA-07234: slemcw: fseek error.
CLSR-00518: Failed to register a preconnect service name
ORA-13802: failed to purge SQL Tuning Base entry from sql$
ORA-02228: duplicate SIZE specification
ORA-02853: Invalid server list latch time out value
TNS-12688: Login failed: the SecurID server rejected the new pincode
ORA-29265: HTTP header not found
DRG-12219: section name missing
ORA-13799: threshold not found