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


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

ORA-12992: cannot drop parent key column

1 Answers  


ORA-24400: error occured while creating connections in the pool

1 Answers  


ORA-16186: Modifying LOG_ARCHIVE_CONFIG requires SID='*' qualifier

1 Answers  


ORA-31640: unable to open dump file "string" for read

1 Answers  


ORA-01645: previous attempt to make read write is half complete

1 Answers  






PLS-01501: Options in CREATE TABLE statement is non-ANSI.

1 Answers  


ORA-27488: unable to set string because string was/were already set

1 Answers  


ORA-37040: (XSACQUIRE_DEP_LOCKED) Composite, concat, dimension map, or internal partition workspace object is locked by another user.

1 Answers  


ORA-29662: Unable to find a field that matches one or more of the attributes

1 Answers  


ORA-19766: missing CHANGE keyword

1 Answers  


NNO-00851: LDAP open/bind failed: error = number

1 Answers  


ORA-36686: (XSDPART24) Value number is not in partition number.

1 Answers  






Categories