SQL*Loader-00486: sql-strings may not be specified for
collection field string
- 1 Answers
- 2496 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: A sql-string was specified as part of the description
of the field that is inside a nested table or varray.
Sql-strings cannot be used to load a field in a varrary or
nested tables.
Action: Remove the sql-string from the field description.
Modify the data file so that it contains the values to be
loaded into the column in the collection.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
DRG-13000: error while adding or removing a sub lexer
LPX-00011: In line ~1u of ~2s [general entity ~3S]:
ORA-24342: unable to destroy a mutex
ORA-09841: soacon: Name translation failure.
ORA-16813: apply service not running on the apply instance string recorded by the broker
NZE-29006: The certificate request message is invalid when using SSL 2.0.
ORA-02160: index-organized table can not contain columns of type LONG
TNS-00019: INTCTL: error initializing the national language interface
DRG-11706: invalid relation string
EXP-00040: Dump file and log file must be different
ORA-26724: only SYS is allowed to set the Capture or Apply user to SYS.
TNS-12660: Encryption or crypto-checksumming parameters incompatible
Oracle Errors 
