SQL*Loader-00476: count of elements for collection is not
set or null, 0 will be used



SQL*Loader-00476: count of elements for collection is not set or null, 0 will be used..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LPX-00224: multiple occurrences of attribute "~S" found

1 Answers  


ORA-24191: the property name string has existed

1 Answers  


KUP-04059: found EOF in length portion of VARIABLE record in file string

1 Answers  


ORA-24762: server failed due to unspecified error

1 Answers  


ORA-00205: error in identifying controlfile, check alert log for more info

2 Answers   TechValley,






ORA-30370: set operators are not supported in this context

1 Answers  


ORA-28533: Heterogeneous Services coercion handling error

1 Answers  


ORA-30034: Undo tablespace cannot be specified as temporary tablespace

1 Answers  


RMAN-08042: channel string: copied standby controlfile

1 Answers  


ORA-02440: Create as select with referential constraints not allowed

1 Answers  


NNL-00221: Statistic counter logging interval is now string

1 Answers  


ORA-19212: no key columns specified before call to DBMS_XMLSTORE.updateXML()

1 Answers  


Categories