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-01234: cannot end backup of file string - file is in use or recovery

1 Answers  


RMAN-06280: Report of obsolete backups and copies

1 Answers  


NNO-00082: domain "string" is missing my name "string" as a name server

1 Answers  


LPX-00241: entity reference is not well formed

1 Answers  


NNO-00631: warning: forwarder number has invalid name "string", forwarder ignored

1 Answers  






PLS-01400: Use of '||' token

1 Answers  


NPL-00101: uninitialized ASN.1 context

1 Answers  


RMAN-06716: skipping datafile number; already restored to file string

1 Answers  


ORA-28278: No domain policy registered for password based GLOBAL users.

1 Answers  


ORA-31025: Invalid document element

1 Answers  


TNS-01024: Trace Level string

1 Answers  


PLS-01912: : instance must of be of type 'string'

1 Answers  


Categories