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

PLS-00304: cannot compile body of 'string' without its specification

1 Answers  


QSM-00776: the user-defined workload string is missing the following column: 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-08008: another instance is mounted with USE_ROW_ENQUEUES = string

1 Answers  


PLS-00358: column 'string' exists in more than one table; use qualifier

1 Answers  






ORA-12595: TNS:no confirmation

1 Answers  


RMAN-06186: PL/SQL package string.string version string in string database is too old

1 Answers  


ORA-08401: invalid compiler name: string

1 Answers  


ORA-09976: skxfqdini: Error Creating Port

1 Answers  


ORA-16113: applying change to table or sequence string

1 Answers  


DRG-13103: index table string is partitioned

1 Answers  


ORA-09854: snyPortInfo: bad return code from request.

1 Answers  


Categories