Xref: alice comp.databases.oracle.misc:33876
Path: alice!news-feed.fnsi.net!news.idt.net!newshub.northeast.verio.net!news-feed1.tiac.net!posterchild2!news@tiac.net
From: "Hank Riehl" <hankr@skillview.com>
Newsgroups: comp.databases.oracle.misc
Subject: SQL Anywhere to Oracle data migration
Date: Fri, 18 Jun 1999 07:48:56 -0400
Organization: The Internet Access Company, Inc.
Lines: 25
Message-ID: <7kdbeh$7nv@news-central.tiac.net>
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

We need to port data from SQL Anywhere to Oracle.

Some long character columns' data contains embedded CR-LFs
(Carriage-Returns/Line-Feeds) to provide user-formatting within the
column-data.

SQL Anywhere exports this info into ascii as ' \x0D\x0A ' (unquoted), simply
embedded in the column's data-string. On import, SQL Anywhere recognizes
this as an embedded CR-LF but Oracle simply treats it as part of the literal
column-string

The question is what does Oracle want to see in ascii to embed a CR-LF
within the column-data?   We know we need to de a global search-replace on
the ascii files between export and import, but don't know what to replace it
with so Oracle treats it properly.

Any help greatly appreciated.

Hank