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-14277: tables in EXCHANGE SUBPARTITION must have the same number of columns
ORA-06258: NETNTT: cannot allocate context area
CLSR-00517: Failed to register a service name
PCB-00008: Must use option SQLCHECK=SEMANTICS(FULL) when there is embedded PL/SQL
PCB-00215: OCCURS TO TIMES clause not allowed for host variable "string"
ORA-29518: name string resolved to an object in schema string that is not a Java class
ORA-16058: standby database instance is not mounted
ORA-17502: ksfdcre:string Failed to create file string
ORA-07483: snlkget: cannot convert(get) lock.
RMAN-08006: database registered in recovery catalog
TNS-00296: Stoppable : string
ORA-28651: Primary index on IOTs can not be marked unusable