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


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

ORA-23452: flavor string of object group "string"."string" is already published

1 Answers  


SQL*Loader-00915: Error closing cursor: [number]

1 Answers  


ORA-02029: missing FILE keyword

1 Answers  


ORA-19040: Element string does not match expected string.

1 Answers  


ORA-14292: Partitioning type of table must match subpartitioning type of composite partition

1 Answers  






PROT-00015: Unimplemented feature

1 Answers  


DRG-11823: Not Found

1 Answers  


ORA-10920: Cannot offline tablespace belonging to default temporary tablespace group

1 Answers  


NNL-00241: Processing of modification requests is currently enabled

1 Answers  


NNL-00400: Response status:

1 Answers  


ORA-31621: error creating master process

1 Answers  


RMAN-03009: failure of string command on string channel at string

1 Answers  






Categories