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-00209: control file blocksize mismatch, check alert log for more info
ORA-19590: conversation already active
TNS-01077: Opened parameter file: string
ORA-16589: Data Guard Connection process detected a network transfer error
ORA-31619: invalid dump file "string"
ORA-07229: slcpuc: error in getting number of CPUs.
ORA-16598: Data Guard broker detected a mismatch in configuration.
NNO-00308: server will restart in number seconds
ORA-01156: recovery in progress may need access to files
ORA-30731: scope constraint not allowed on nested table column when the nested table is being created
LSX-00333: literal "~S" is not valid with respect to the pattern
NNL-00260: Server-generated requests now do not require authoritative answers