SQL*Loader-00487: COUNT clause required for collection string



SQL*Loader-00487: COUNT clause required for collection string..

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

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00475: field for dynamic file name is string in table string

1 Answers  


DRG-50860: failed to prepare statement

1 Answers  


EXP-00093: Could not convert to server character set's handle

2 Answers  


TNS-02524: Authentication: privilege check failed

1 Answers  


IMG-00556: incorrect number of gamma values

1 Answers  






IMG-00513: missing value in scaling operation

1 Answers  


ORA-22608: cannot add an attribute to the already generated image handle

1 Answers  


ORA-14071: invalid option for an index used to enforce a constraint

1 Answers  


ORA-00273: media recovery of direct load data that was not logged

1 Answers  


ORA-02308: invalid option string for object type column

1 Answers  


ORA-18003: an outline already exists with this signature

1 Answers  


RMAN-08540: channel string: backup set complete, elapsed time: string

1 Answers  


Categories