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

AMD-00101: cannot create string "string"; metadata entity already exists

1 Answers  


QSM-02185: no partition key or PMARKER in select list

1 Answers  


TNS-04015: Current instance string is not yet started

1 Answers  


NNO-00711: cache dump countdown aborted

1 Answers  


ORA-00723: Initialization parameter COMPATIBLE must be explicitly set

1 Answers  






ORA-29533: attempt to overwrite class or resource string while defining or compiling string.string

1 Answers  


ORA-33003: (XSAGDIMDROP) workspace object, to be transformed during data load, must be a base dimension and not otherwise referenced in the AGGMAP.

1 Answers  


ORA-15197: suppressing string additional ASM messages

1 Answers  


ORA-06123: NETTCP: cannot set KEEPALIVE

1 Answers  


QSM-01130: Multi MV rewrite not allowed if at least one query block has no MVs

1 Answers  


TNS-00540: SSL protocol adapter failure

1 Answers  


ORA-25280: complete sender information not provided to non-repudiate sender

1 Answers  


Categories