SQL*Loader-00424: table string makes illegal reference to
collection field string



SQL*Loader-00424: table string makes illegal reference to collection field string..

Answer / guest

Cause: A WHEN, OID or SID clause for the table refers to a
field declared inside of a collection.

Action: Move the data containing the value for a SID or OID
clause outside of the collection definition.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-30731: scope constraint not allowed on nested table column when the nested table is being created

1 Answers  


ORA-27366: job "string.string" is not running

1 Answers  


KUP-04060: field string referenced by lobfile column string not found

1 Answers  


ORA-30510: system triggers cannot be defined on the schema of SYS user

1 Answers  


DGM-16910: unable to issue command to server

1 Answers  






NNF-01006: Attribute string not available

1 Answers  


ORA-36999: (XSRELGID16) OBJECT workspace object is not a surrogate dimension, a source relation must be specifed when creating any non-surrogate grouping id.

1 Answers  


ORA-02163: invalid value for FREELIST GROUPS

1 Answers  


NNL-00934: Requests refused, ALIAS-EXISTS violation: number

1 Answers  


ORA-14504: syntax not supported for analyze

1 Answers  


ORA-02275: such a referential constraint already exists in the table

1 Answers  


LFI-00003: Internal exception code. icode = [string], [string].

1 Answers  


Categories