RE: SQL Server To Oracle

Flat file only allows for tab delimited. It still does the same thing, create a new row for each CR, which SQL*Loader doesn't like.

Scott Canaan '88
Sr Database Administrator
Information & Technology Services
Finance & Administration
Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520
srcdco_at_rit.edu<mailto:srcdco_at_rit.edu> | c: (585) 339-8659

CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information.

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Mark W. Farnham Sent: Thursday, March 10, 2022 12:24 PM
To: Scott Canaan <srcdco_at_rit.edu>; oracle-l_at_freelists.org Subject: RE: SQL Server To Oracle

Did you already try using flat file output option and choosing comma as your delimiter?

It has been a long time for me (since before MS bought sql server), so of course things may have changed.

From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Scott Canaan Sent: Thursday, March 10, 2022 12:02 PM
To: 'oracle-l_at_freelists.org'
Subject: SQL Server To Oracle

I'm trying to get some data from a SQL Server 2012 database into an Oracle 19c database on Linux. I'm having trouble with the CLOB fields (text in SQL Server). When I export the data to a csv, it splits the data in that is larger into several rows, which SQL*Loader doesn't like. I don't know how to get the data exported so I can use it or to import the data as it is. If anyone has any suggestions, I'd really appreciate it.

Thank you,

Scott Canaan '88
Sr Database Administrator
Information & Technology Services
Finance & Administration
Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520
srcdco_at_rit.edu<mailto:srcdco_at_rit.edu> | c: (585) 339-8659 CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information.

--
http://www.freelists.org/webpage/oracle-l