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

NNL-00037: Error number while sequencing through parameter table.

1 Answers  


ORA-12046: cannot use trusted constraints for refreshing remote MV

1 Answers  


ORA-39126: Worker unexpected fatal error in string [string] string

1 Answers  


ORA-07451: slskstat: unable to obtain load information.

1 Answers  


RMAN-08180: channel string: restore complete, elapsed time: string

1 Answers  






ORA-16748: Resource guard encountered errors during database open

1 Answers  


RMAN-06129: invalid reserved channel ID: string

1 Answers  


EXP-00073: dump file size too small

1 Answers  


ORA-24361: basic bind call not invoked before invoking advanced bind call

1 Answers  


RMAN-00552: syntax error in command line arguments

1 Answers  


ORA-10588: Can only allow 1 corruption for normal media/standby recovery

1 Answers  


ORA-01977: Missing thread number

1 Answers  


Categories