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

PLS-00450: a variable of this private type cannot be declared here

1 Answers  


SQL*Loader-00918: The catalog must be loaded (as SYS) for SQL*Loader to be used

1 Answers  


NNO-00802: Error: OCI_NEED_DATA

1 Answers  


ORA-27419: unable to determine valid execution date from repeat interval

2 Answers  


ORA-00266: name of archived log file needed

1 Answers  






IMG-02008: 2FF08 - color histogram feature cannot be determined

1 Answers  


NNC-00405: network failure

1 Answers  


ORA-29664: Unable to generate the helper class for the defined type

1 Answers  


RMAN-20240: archived log not found in the recovery catalog

1 Answers  


ORA-01061: cannot start up a V8 server using a V7 client application

1 Answers  


TNS-01053: Connecting to string

1 Answers  


ORA-07635: smsdbp: $SETPRT failure

1 Answers  


Categories