SQL-02147: ANSI Dynamic occurrence value out of range
Cause: The value clause in a dynamic GET or SET statement is less than one or greater than MAX given for descriptor allocation.
Action: Supply a number for the VALUE clause between 1 and the MAX occurrences supplied when the descriptor was allocated.
SQL-02148
Custom Search


More Oracle errors
ORA-47382OLS Policy Label string not found for policy string
QSM-02075materialized view on synonym
RMAN-06004ORACLE error from recovery catalog database: string
ORA-25191cannot reference overflow table of an index-organized table
ORA-07569slspool: $CLOSE failure
ORA-01563rollback segment is PUBLIC, need to use the keyword PUBLIC
ORA-27034maximum length of ORACLE_SID exceeded
SQL*Loader-00706Bad argument to ulerr [number].
OCI-21526initialization failed
ORA-02383illegal cost factor
ORA-07304ksmcsg: illegal redo buffer size.
TNS-12222TNS:no support is available for the protocol indicated
RMAN-06455Tablespace Point-in-Time Recovery requires Enterprise Edition
ORA-26651Unable to start or stop capture process string
ORA-26765invalid parameter "string" for downstream capture "string"
RMAN-10001error parsing recovery catalog connect string "string"
ORA-24757duplicate transaction identifier
ORA-00723Initialization parameter COMPATIBLE must be explicitly set
PCC-02424The number of values and host variables does not match
ORA-31103Resource locked in shared mode. Cannot add exclusive lock




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
SQL-02147ANSI Dynamic occurrence value out of range