ORA-30486: invalid window aggregation group in the window
specification



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

Post New Answer

More Oracle Errors Interview Questions

RMAN-08074: crosschecked backup piece: found to be 'string'

1 Answers  


ORA-08331: Wait operation timed out

1 Answers  


ORA-27451: %s cannot be NULL

1 Answers  


ORA-01645: previous attempt to make read write is half complete

1 Answers  


CLSR-00510: Unable to load NLS data

1 Answers  






SQL*Loader-00276: Local storage option overrides global storage.

1 Answers  


DRG-10839: invalid ORDER argument supplied to NEAR

1 Answers  


LSX-00222: "~1S" is too long (maximum length is ~2d)

1 Answers  


ORA-19579: archivelog record for string not found

1 Answers  


O2F-00339: CODE option has an illegal value

1 Answers  


DRG-11815: Not Modified

1 Answers  


DRG-11527: end token not found on line string

1 Answers  


Categories