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-07489: scgrcl: cannot get lock status.
ORA-16733: Error executing dbms_logstdby.unskip procedure
ORA-14612: Duplicate lob segment name string for lob column string in template
DRG-50919: NEAR operand not a phrase, equivalence or another NEAR expression
ORA-08275: Environment variable unset
IMP-00047: unexpected file sequence number; expected number but found number
IMG-00716: source image format does not support process options
ORA-15048: ASM internal files cannot be deleted
ORA-24790: cannot mix OCI_TRANS_RESUME and transaction isolation flags
AMD-00106: parent string "string" must be removed before child string "string" can be removed
ORA-06973: X.25 Driver: invalid buffer size
PLS-00491: numeric literal required