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

NZE-28800: data source failed to open

1 Answers  


ORA-06746: TLI Driver: cannot alloc t_call

1 Answers  


ORA-16583: bad Data Guard Connection Process DRCX state

1 Answers  


NNO-00112: line string: ignored duplicate data of type "string"

1 Answers  


ORA-00330: archived log ends at change string, need change string

1 Answers  






ORA-29541: class string.string could not be resolved

1 Answers  


PLS-00510: Float cannot have scale

1 Answers  


NZE-29010: Export key length does not meet export restrictions.

1 Answers  


ORA-06708: TLI Driver: message receive failure

1 Answers  


IMG-00604: unable to access destination image data

1 Answers  


LPX-00215: processing instruction did not end in "?>"

1 Answers  


ORA-09944: Password entry is corrupt.

1 Answers  


Categories