SQL*Loader-00487: COUNT clause required for collection string
- 1 Answers
- 2159 Views
- I also Faced
- E-Mail Answers
Answer / guest
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.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
RMAN-03014: implicit resync of recovery catalog failed
TNS-01415: Listening Endpoints Summary...
NZE-29223: Cannot create certificate chain.
PLS-00147: LIBRARY file specification string is empty
DRG-51020: out of memory in fuzzy matcher
SQL*Loader-00624: no terminator found after TERMINATED and ENCLOSED field
NID-00602: Could not allocate number bytes for "string"
ORA-24387: Invalid attach driver
EXP-00025: dictionary shows no column for constraint string.number
ORA-14164: subpartition "string": INITRANS value must be less than MAXTRANS value
DGM-16991: More than one resources have name "string".
ORA-01371: Complete LogMiner dictionary not found
Oracle Errors 
