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-12589: TNS:connection not bequeathable
RMAN-06524: RMAN retention policy will be applied to the command
ORA-00293: controlfile out of sync with redo log
ORA-02365: error seeking in file: string
ORA-00151: invalid transaction ID
ORA-28044: unsupported directory type
ORA-36394: (XSMXCLEA04) When using CLEAR on the AGGMAP workspace object, CACHE is the only valid directive.
ORA-30389: the source statement is not compatible with the destination statement
ORA-10565: Another test recovery session is active
ORA-02700: osnoraenv: error translating ORACLE_SID
ORA-06043: NETDNT: message send failure
ORA-30106: reserved for future use