SQL*Loader-00486: sql-strings may not be specified for
collection field string



SQL*Loader-00486: sql-strings may not be specified for collection field string..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-15056: additional error message

1 Answers  


PLS-00654: PARTITION/ORDER/CLUSTER BY are allowed for only with PARALLEL_ENABLE

1 Answers  


RMAN-08001: restore not complete

1 Answers  


RMAN-10015: error compiling PL/SQL program

1 Answers  


PCC-02448: Cannot specify a UCS2 variable in the NLS_NCHAR option

1 Answers  






ORA-29359: invalid method name string specified for resource plan string

1 Answers  


SQL*Loader-00623: second enclosure string not present

1 Answers  


PCC-02407: Object and REF types do not match

1 Answers  


RMAN-06127: skipping read-only file string

1 Answers  


ORA-06259: NETNTT: cannot read from remote process

1 Answers  


RMAN-06168: no backup pieces with this tag found: string

1 Answers  


ORA-29502: NAMED keyword required in CREATE JAVA RESOURCE

1 Answers  


Categories