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 |
QSM-00778: the specified output filename string is invalid or cannot be accessed
QSM-01123: self-join algorithm could not resolve multiple instances
ORA-00073: command string takes between string and string argument(s)
ORA-26004: Tables loaded through the direct path may not be clustered
SQL*Loader-00919: Error during upi fetch: [number]
ORA-06302: IPA: Cannot connect to remote host
TNS-12229: TNS:Interchange has no more free connections
LPX-00303: attribute value "~S" not expected for ~S
TNS-12201: TNS:encountered too small a connection buffer
ORA-31222: DBMS_LDAP: PL/SQL - Invalid LDAP SSL authentication mode.
ORA-12491: DBHIGH value does not dominate DBLOW
ORA-29966: The only binding of an operator cannot be dropped