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-16101: a valid start SCN could not be found

1 Answers  


ORA-25006: cannot specify this column in UPDATE OF clause

1 Answers  


NNO-00334: region load failure: ROS admin_region type number unsupported

1 Answers  


SQL*Loader-00120: Invalid _synchro option string

1 Answers  


ORA-32316: REFRESH FAST of "string"."string" unsupported after mixed DML

1 Answers  


ORA-29806: specified binding does not exist

1 Answers  


ORA-00319: log string of thread string has incorrect log reset status

1 Answers  


RMAN-08550: autobackup search outside recovery area not attempted because DBID was not set

1 Answers  


ORA-12023: missing index on materialized view "string"."string"

1 Answers  


ORA-00911: invalid character

1 Answers  


ORA-26508: null materialized view connection

1 Answers  


ORA-32101: cannot create OCI Environment

1 Answers  


Categories