Solved

SQL LOADER:carraige return inside field value

Posted on 1998-10-08
2
1,145 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

756 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