machiel.richards wrote:
Good day guys
[snip]
. Each item in the "text" field is added in the field by entering
the country name then pressing enter and then entering the next, etc....
. When exporting the data to a file (even when enclosing each field
within quotes) it still writes the control characters causing each item to
be read as a different line and thus the import into Oracle fails.
Any idea on how we can resolve this as the process needs to be cronned to
run on a weekly basis and thus we need to get this process resolved.
You haven't described what process you're using to read the file for the Oracle
import - all of Oracle's interfaces (oci, SQL, PL/SQL, load utilities like
SQL*Loader and imp/impdp, external tables, etc.) can handle multi-line records
like this. Given you're dumping to a file, it's mostly likely you're using
SQL*Loader (i.e. sqlldr). The INFILE clause for the control file includes an
os_file_proc_clause which let's you set the record delimiter, and override the
default end of line behaviour.
See
http://www.orafaq.com/wiki/SQL*Loader_FAQ#How_does_one_load_records_with_multi-line_fields.3F
for an example.
If you're not using SQL*Loader, then more info would be required.
Ciao
Fuzzy
:-)
------------------------------------------------
Dazed and confused about technology for 20 years
http://fuzzydata.wordpress.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
