Solved

SQL LOADER:carraige return inside field value

Posted on 1998-10-08
2
1,138 Views
Last Modified: 2008-02-01
I am trying to load data into Oracle using SQL Loader. One field is of datatype varchar(255) and has carraige returns inside it. When I try to load the data it takes the carraige return , line feed as an end of line and tries to continue after that and the operation fails. Is there a way to handle this? As a last option I will write a script to search and replace all such CR and LF with some other character, but I was wondering if this could be tackled in any way other than that. I am bcp ing out the data from Sybase and loading it to Oracle. Basically how can I specify a different row terminator other than CR and LF and load the file using SQL Loader.
0
Comment
Question by:jbiswas
2 Comments
 
LVL 3

Accepted Solution

by:
junfeb earned 100 total points
ID: 1081898
SQL*LOADER in the way it works treats CR as end of row. There isn't an easy way to tell it to not treat CR as end of current row. So I guess you need to start writing that script to get rid of the CR if you want to use sql*loader to load the data.

Thanks.
0
 

Expert Comment

by:jacs
ID: 1081899
You can try with this options

* Use RECLEN sentence to set then oy de row.

* Use the CONCATENATE option to set a number of lines inside
a row.

* Use TERMINATED sentence to set the terminator for the fields.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now