Re: Problems with SQL*Loader and ORACLE 6
Date: 9 Mar 1995 01:52:26 GMT
Message-ID: <3jln0q$9k7_at_dcsun4.us.oracle.com>
Is it possible that the data contains " characters and that is screwing up the enclosed by? Check the data stream
Mike Bearne (comrmb_at_herts.ac.uk) wrote:
: 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.
-- Kirk Bradley Oracle Corporation Mainframe and Integration Technologies GroupReceived on Thu Mar 09 1995 - 02:52:26 CET