SQL*Loader-00288: Delimiters may not be specified for
collections stored in SDF.



SQL*Loader-00288: Delimiters may not be specified for collections stored in SDF...

Answer / guest

Cause: A TERMINATED BY or ENCLOSED BY clause was found along
with an SDF (secondary data files) clause for a nested table
or varray field.

Action: The TERMINATED BY or ENCLOSED BY clauses may be
specified only if the nested table or VARRAY data is stored
in the record in the main data file. If you are loading
nested table or VARRAY data from a secondary data file, then
you must use COUNT to indicate the number of elements in the
secondary data file that are stored in the file.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13046: invalid number of arguments

1 Answers  


ORA-12235: TNS:Failure to redirect to destination

1 Answers  


NCR-03002: NCRO: Maximum number of contexts has been reached

1 Answers  


ORA-14170: cannot specify <partition-description> clause in CREATE TABLE|INDEX

1 Answers  


ORA-39313: illegal clone() call: clone has been done before

1 Answers  


LSX-00024: unknown attribute group "~S"

1 Answers  


PCC-02202: No typedef name was given

1 Answers  


ORA-13126: unable to determine class for spatial table string

1 Answers  


DRG-13005: alt_value cannot be an NLS language name

1 Answers  


ORA-09937: Chmod of ORACLE password file failed.

1 Answers  


NNO-00109: line string: invalid data type name "string", data ignored

1 Answers  


ORA-09755: osngpn: port allocation failure.

1 Answers  


Categories