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-07471: snclrd: name translation error of sgadef.dbf file name.

1 Answers  


ORA-10578: Can not allow corruption for managed standby database recovery

1 Answers  


ORA-34361: (MXDSS12) number other user reading

1 Answers  


LPX-00019: property "~s" unknown

1 Answers  


ORA-27001: unsupported device type

1 Answers  


ORA-28112: failed to execute policy function

1 Answers  


ORA-12652: String truncated

1 Answers  


ORA-02712: osnpop: malloc failed

1 Answers  


ORA-12089: cannot online redefine table "string"."string" with no primary key

1 Answers  


QSM-00763: the owner string is invalid while validating user-defined workload string.string

1 Answers  


ORA-12635: No authentication adapters available

1 Answers  


ORA-23315: repcatlog version or request string is not supported by version string

1 Answers  


Categories