You may want to add CONTINUEIF clause and try the load again
...
infile 'data.asc'
CONTINUEIF NEXT (1) != '"'
into table test
...
For complete reference, see this URL:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch05.htm#1005518
--
Thanks,
Krishna
~~
Thank you for answer. I did not said clearly. Most
records are fine. ONly some records have this
problem.
re-transfer from PC to UNIX will not fix problem.
--- Nikhil Khimani <[EMAIL PROTECTED]> wrote:
> This is a hack but ... you might want to look into
> ftp-ing a file to Unix,
> run a '
So, why don't you use migration workbench, when it's available?
On 01/29/2004 10:34:27 AM, dba1 mcc wrote:
We are migrate from MS Access to ORACLE(9.2.0.4) use
SQL*Loader. The problem we have are some of MS Access
dump records (ASCII output) have to several lines(EOL
before end of record). For e
This is a hack but ... you might want to look into ftp-ing a file to Unix,
run a 'tr' or 'sed' to get rid of the EOL character.
Thanks,
Nikhil
-Original Message-
Sent: Thursday, January 29, 2004 10:34 AM
To: Multiple recipients of list ORACLE-L
We are migrate from MS Access to ORACLE