SQL*Loader-00487: COUNT clause required for collection string
- 1 Answers
- 1614 Views
- I also Faced
- E-Mail Answers
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-23452: flavor string of object group "string"."string" is already published
SQL*Loader-00915: Error closing cursor: [number]
ORA-02029: missing FILE keyword
ORA-19040: Element string does not match expected string.
ORA-14292: Partitioning type of table must match subpartitioning type of composite partition
PROT-00015: Unimplemented feature
DRG-11823: Not Found
ORA-10920: Cannot offline tablespace belonging to default temporary tablespace group
NNL-00241: Processing of modification requests is currently enabled
NNL-00400: Response status:
ORA-31621: error creating master process
RMAN-03009: failure of string command on string channel at string
Oracle Errors 
