Re: SQL Server To Oracle

After spending some time reading the LOB loading bit, I'm not sure that you can tell it to concatentate several rows to rebuild the lob. (It's happy to take the bits and call them one LOB, but that leaves with a LOB holding CR/LF every N characters.

Apart from the other suggestions you've had about ways that you can use SQL Server or Oracle to handle the problem, another possibility crossed my mind - could you declare an external table and include a preprocessor in the definition. If you can write a preprocessor that would take the fragments of LOB and concatenate them that might work.

Regards
Jonathan Lewis

On Thu, 10 Mar 2022 at 18:35, Jonathan Lewis <jlewisoracle_at_gmail.com> wrote:

>
> Have you been playing around with the type strategy suggested at:
>
> https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/loading-objects-oracle-sql-loader.html#GUID-DC800D62-FC91-4CF6-ADC5-1D9CF00621BB
> (something like example 11-18).
>
> How flexible is SQL server about dumping to file with
> a) a special character starting each row
> b) delimiting a column with special text
> c) restricting explicitly the number of characters per line when it wraps
> the CLOB?
>
> Is part of the problem that you have CRLF characters inside the text
> column ?
>
> Regards
> Jonathan Lewis
>
>
> On Thu, 10 Mar 2022 at 17:02, Scott Canaan <srcdco_at_rit.edu> wrote:
>
>> 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 <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