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

ORA-01216: thread string is expected to be disabled after CREATE CONTROLFILE

1 Answers  


TNS-00110: Could not initialize network from file TNSNET.ORA

1 Answers  


ORA-16546: missing or invalid piece

1 Answers  


ORA-14326: Primary index on an IOT, DOMAIN and LOB indexes may not be specified in the UPDATE INDEXES clause

1 Answers  


ORA-06748: TLI Driver: cannot allocate t_discon

1 Answers  






ORA-24012: cannot drop QUEUE_TABLE, some queues in string have not been dropped

1 Answers  


ORA-02728: osnfop: access error on oracle executable

1 Answers  


ORA-38402: invalid name: empty string or spaces in the name

1 Answers  


ORA-39120: Table string can't be truncated, data will be skipped. Failing error is: string

1 Answers  


PLS-00377: internal type PLS_INTEGER is not included in this release of PL/SQL

1 Answers  


DRG-51023: stemmer file cannot be opened

1 Answers  


LPX-00210: expected '~1c' instead of '~2c'

1 Answers  


Categories