Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-31455: nothing to ALTER

1 Answers  


ORA-22891: cannot have multiple columns in REF constraint

1 Answers  


ORA-16092: dependent archive log destination is not active

1 Answers  


ORA-06742: TLI Driver: cannot alloc t_bind

1 Answers  


DRG-10311: remote send not supported

1 Answers  






SAP log on Error Message: "Msg E14 645 not found"

0 Answers  


ORA-29557: Java system class string cannot be modified

1 Answers  


ORA-29266: end-of-body reached

1 Answers  


SQL*Loader-00710: Internal error: direct path stream buffer not loaded

1 Answers  


ORA-30757: cannot access type information

1 Answers  


ORA-06140: NETTCP: no such user

1 Answers  


ORA-19764: database id string does not match database id string in control file

1 Answers  






Categories