SQL*Loader-00476: count of elements for collection is not set or null, 0 will be used
Cause: This message is displayed following a message that identifies the column and row that contained the problem. The message indicates that the collection field named in the previous message has the count of elements in the collection stored in another field. This message is displayed if the field containing the count does not have a value or is set to NULL. When this happens, SQL*Loader uses 0 as the number of elements.
Action: If 0 is not the count of elementsfor the collection, correct the data in the data file.
SQL*Loader-00477
Custom Search


More Oracle errors
ORA-14310VALUES LESS THAN or AT clause cannot be used with List partitioned tables
RMAN-08034full resync skipped, target database not mounted
NZE-28766failure to terminate use of data source
PCC-02424The number of values and host variables does not match
ORA-06413Connection not open.
KUP-01007at line number column number
ORA-19124FORG0004: fn:one-or-more() called with a sequence containing no items
ORA-39934Materialized view log string.string in tablespace string and master table string.string in tablespace
TNS-12657No algorithms installed
ORA-13189recursive SQL parse failed
ORA-31109Action failed as parent resource string is locked
DRG-50850string
ORA-16776health check of the redo transport service failed
ORA-46108Invalid security class targetNamespace or name.
ORA-30645reject limit out of range
ORA-15109conflicting protection attributes specified
NZE-28861SSL connection would block
ORA-26760Could not find message number string for transaction with id string
IMG-00587output format does not support the specified scanlineOrder
ORA-00991only MAC privileges may be granted to procedures




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*Loader-00476count of elements for collection is not set or null, 0 will be used