Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

EXP-00095: Flashback_time and Flashback_scn are not compatible

1 Answers  


ORA-01258: unable to delete temporary file string

1 Answers  


RMAN-08054: starting media recovery

1 Answers  


ORA-01570: MINEXTENTS must be no larger than the string extents currently allocated

1 Answers  


RMAN-06195: auxiliary database not started

1 Answers  






ORA-13410: invalid layerNumbers or bandNumbers parameter

1 Answers  


RMAN-06496: must use the TO clause when the database is mounted or open

1 Answers  


ORA-06406: NETCMN: error sending break message

1 Answers  


LPX-00608: Repeated declaration of '~1S' in element '~2S'.

1 Answers  


DRG-12015: The source document for this operation has moved - continue?

1 Answers  


ORA-29296: invalid encoded string

1 Answers  


ORA-29880: such column list already indexed using another domain index and indextype

1 Answers  






Categories