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 |
ORA-16101: a valid start SCN could not be found
ORA-25006: cannot specify this column in UPDATE OF clause
NNO-00334: region load failure: ROS admin_region type number unsupported
SQL*Loader-00120: Invalid _synchro option string
ORA-32316: REFRESH FAST of "string"."string" unsupported after mixed DML
ORA-29806: specified binding does not exist
ORA-00319: log string of thread string has incorrect log reset status
RMAN-08550: autobackup search outside recovery area not attempted because DBID was not set
ORA-12023: missing index on materialized view "string"."string"
ORA-00911: invalid character
ORA-26508: null materialized view connection
ORA-32101: cannot create OCI Environment