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 |
KUP-03003: absolute end(number) - start(number) != fieldlength (number) for field string
ORA-30131: number of keys being set exceeds allocation
ORA-14183: TABLESPACE DEFAULT can be specified only for Composite LOCAL index
ORA-01109: database not open
ORA-00445: background process "string" did not start after string seconds
ORA-02185: a token other than WORK follows COMMIT
NNL-00224: Scheduled statistic counters to be logged in string
TNS-04001: %s
RMAN-06479: WARNING: control file copy 'string' cannot be found on disk
LFI-00138: Unable to perform string on a name object that is string.
ORA-16555: The Data Guard database is not active.
SQL*Loader-00252: Sort data sets are not used by SQL*Loader