ORA-30486: invalid window aggregation group in the window specification
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
ORA-30487
Custom Search


More Oracle errors
ORA-06516PL/SQL: the Probe packages do not exist or are invalid
ORA-07494scgcm: unexpected error.
NZE-28828invalid identity type passed
ORA-09777osnpbr: cannot send break message
ORA-31655no data or metadata objects selected for job
NCR-04014NCRR: Invalid instance name
ORA-41649invalid rule condition for a rule class involving composite events
NZE-28820Signature or decryption/encryption state is not provided.
EVM-00701Check that the event is registered and you are authorized to post it
ORA-38869datafile string has been restored from an RMAN backup with undo block compression.
ORA-09888osnTXtt: txipc channel creation failed
ORA-30078partition bound must be TIME/TIMESTAMP WITH TIME ZONE literals
NZE-29247an unopen toolkit object was used before it was opened
TNS-00553read failed
ORA-16281missing identification key for table "string"."string".
RMAN-06136ORACLE error from auxiliary database: string
ORA-31606XML context number does not match any previously allocated context
ORA-12436no policy options specified
RMAN-08088applied offline range to datafile string
ORA-12626TNS:bad event type




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16665timeout waiting for the result from a database
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
ORA-16766Redo Apply is stopped
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-00001unique constraint (string.string) violated
ORA-55508Invalid input to Flashback Transaction Backout




Your own TOP 20 Oracle errors
ORA-30486invalid window aggregation group in the window specification