SQL*Loader-00270: TERMINATED BY EOF valid only for CHAR or
RAW datatypes



SQL*Loader-00270: TERMINATED BY EOF valid only for CHAR or RAW datatypes..

Answer / guest

Cause: A field description in the SQL*Loader control file
used the TERMINATED BY EOF option when the field was not a
RAW or CHAR datatype.

Action: Modify the SQL*Loader control file to either remove
the TERMINATED BY EOF clause or change the datatype for the
field to be CHAR or RAW.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-02174: the materialized view does not have a UNION ALL marker column

1 Answers  


ORA-27036: translation error, unable to expand file name

1 Answers  


TNS-00114: Internal error- Allocation of addresses not performed

1 Answers  


PLS-00146: duplicate external TRUSTED/UNTRUSTED specification in subprogram expression

1 Answers  


NNL-00035: File string or nested IFILEs not found.

1 Answers  






ORA-16636: the object is permanently disabled

1 Answers  


ORA-13764: Value "string" is illegal as a result percentage.

1 Answers  


ORA-30695: JDWP message format problem

1 Answers  


ORA-02809: Jump buffer not valid

1 Answers  


ORA-12706: this CREATE DATABASE character set is not allowed

1 Answers  


ORA-12535: TNS:operation timed out

1 Answers  


AMD-00121: dimension #string: analytic workspace hierarchy not specified

1 Answers  


Categories