SQL*Loader-00476: count of elements for collection is not
set or null, 0 will be used
- 1 Answers
- 1826 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: This message is displayed following a message that
identifies the column and row that contained the problem.
The message indicates that the collection field named in the
previous message has the count of elements in the collection
stored in another field. This message is displayed if the
field containing the count does not have a value or is set
to NULL. When this happens, SQL*Loader uses 0 as the number
of elements.
Action: If 0 is not the count of elementsfor the collection,
correct the data in the data file.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
SQL*Loader-00803: %s field type not supported by External Table
ORA-10576: Give up restoring recovered datafiles to consistent state: some error occurred
ORA-25270: sender info does not match with the actual sender of the message
ORA-31601: Function string cannot be called now that fetch has begun.
ORA-40108: input data contains too few distinct target (string) values
TNS-01106: Listener using listener name string has already been started
QSM-01046: complex join back on correlated columns not allowed (string)
TNS-00218: Current Bytes/Sec. : number
NZE-29180: Unsupported validation protocol
ORA-01663: the contents of tablespace 'string' is constantly changing
ORA-22341: cannot assign supertype instance to subtype
RMAN-06081: error reading datafile header for datafile string, code string
Oracle Errors 
