| SQLLDR - Delimited by NEWLINE [message #330509] |
Mon, 30 June 2008 06:16  |
ttrr
Messages: 1
Registered: June 2008
|
Junior Member |
|
|
Hello everybody,
Hope everyone's Happy  !
Because i am not  , and I have the following problem:
I'm trying to import a CSV from Mysql to Oracle with this
structure:
MYSQL sql export comand:
-------------------------------------
FIELDS TERMINATED BY '$$##$#$#$'
ENCLOSED BY '%%%#&#&#%'
LINES TERMINATED BY '___%%_'
--------------------------------------
My control file:
----------------
load data
infile 'C:\\c002.csv'
into table "table"
RECORDS delimited by '___%%_'
fields terminated by '$$##$#$#$'
optionally enclosed by '%%%#&#&#%'
(field1,field2,free_text)
----------------
The issue here is the field 'free_text', because this field can have newline,\n, or \r\n, I've chose to use LINES TERMINATED BY '___%%_'" in mysql, however I cant Load the file into oracle. It gives the error:
SQL*Loader-350: Syntax Error Line 4.
Expected "(", found "RECORDS".
RECORDS delimited by newline
^
Cant I specify RECORDS delimited by '___%%_' ?
Any Ideas?
Thank you all,
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
