Solved

SQL LOADER:carraige return inside field value

Posted on 1998-10-08
2
1,128 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.

Join & Write a Comment

Suggested Solutions

Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

706 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

17 Experts available now in Live!

Get 1:1 Help Now