Home -> Usenet -> comp.databases.oracle -> Problems with SQL*Loader and ORACLE 6

Problems with SQL*Loader and ORACLE 6

From: Mike Bearne <comrmb_at_herts.ac.uk>
Date: 6 Mar 1995 09:24:59 GMT
Message-ID: <comrmb-060395085426_at_147.197.207.214> 






Hello,



I'm in the process of trying to dump a load of data from some FoxPro tables
(on a PC) into an ORACLE6 database (UNIX).  In the long term I'm going to
use ODBC to get this working however in the short term (*as I dont have the
right ODBC software yet)  I'm trying to get the data into ORACLE dy dumping
it  to a delimited text file and using the SQL*Loader to read it in to
ORACLE.  However I'm having some problems with the loader....



The problems arise when I try to get a fairly large text field from a MEMO
field in FoxPro to a LONG field in ORACLE.  I keep getting the following
sorts of errrors in the loader log file....




Record 1: Warning - logical record longer than specified maximum.
Record 2: Warning - logical record longer than specified maximum.
Record 2: Rejected - Error on table ADVICE, column NAME.


  SQL*Loader-620: Initial enclosing character not found
Record 3: Warning - logical record longer than specified maximum.
Record 3: Rejected - Error on table ADVICE, column NAME.
  SQL*Loader-620: Initial enclosing character not found





Here is a dump of the control file I am using.....





LOAD DATA



INFILE advice.txt


APPEND



INTO TABLE advice


FIELDS TERMINATED BY ',' ENCLOSED BY '"'

(name,advice.no,role,disability,division,author,source,advice
CHAR(5000),pictptr,vidptr)





where 'advice' is the LONG (memo) field.



Can anybody explain why this isn't working ?  I'have tried removing all
carriage returns from the text file but to no avail,



Cheers,



Mike.
Received on Mon Mar 06 1995 - 10:24:59 CET












Original text of this message