SQL*Loader-00487: COUNT clause required for collection string
Cause: A VARRAY or NESTED TABLE was defined in the SQL Loader control file and all of the fields in the VARRAY or NESTED TABLE are generated by SQL Loader and do not come from a data file. SQL Loader requires a COUNT clause be specified so that it knows how many elements to add to the VARRAY or NESTED TABLE for each row.
Action: Add a COUNT clause to the VARRAY or NESTED TABLE definition.
SQL*Loader-00488
Custom Search


More Oracle errors
ORA-09274szrfc: insufficient role name buffer space
ORA-24075cannot specify agent with NULL address and non-NULL protocol
AMD-00158The Workspace "string" is currently open in read-only mode.
ORA-19638file string is not current enough to apply this incremental backup
ORA-53253The metadata for the new DICOM object is invalid.
RMAN-20205incomplete UNTIL clause
ORA-12088cannot online redefine table "string"."string" with unsupported datatype
ORA-12539TNS:buffer over- or under-flow
LPX-00266invalid language specification ~s
ORA-32341The EXPLAIN_MVIEW facility failed to explain the materialized view "string"."string"
ORA-27030skgfwrt: sbtwrite2 returned error
ORA-07682sou2os: set kernel dispatch fail err
ORA-15133instance recovery required for diskgroup string
ORA-09755osngpn: port allocation failure.
DRG-11113value of string must be one of string
PGA-21052error creating file object for trace file
ORA-06932CMX: error in local name
ORA-14314resulting List partition(s) must contain atleast 1 value
NNL-00875Average update processing time: string
ORA-37400analytic workspace does not exist




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-00487COUNT clause required for collection string