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 |
RMAN-06588: number of patterns (number) to DB_FILE_NAME_CONVERT should be even
PCC-01007: WORKING-STORAGE SECTION not found
LSX-00331: missing comma
ORA-24012: cannot drop QUEUE_TABLE, some queues in string have not been dropped
ORA-02288: invalid OPEN mode
PCC-00147: DBMS=V6 no longer supported; using DBMS=NATIVE
PCB-00603: An EXEC TOOLS MESSAGE host variable is not a character type
DRG-11425: gist level string is invalid
SQL*Loader-00429: insufficient number of elements found for varray
ORA-16135: Invalid LOG_ARCHIVE_CONFIG modification while in protected mode
IMG-00812: merged area queue initialization failed
QSM-02163: cannot use object id columns from materialized view log