473,769 Members | 7,375 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

batch loading clobs

i currently have a few (non-oracle) databases containing personal papers of
wellington, mountbatten, etc. i'm thinking about moving it into oracle, but
i'm worried about how to get the data in. the limit on character fields in
the current database system is 65000 characters, and we've run into that a
number of times. i've used sqloader to get data into oracle databases in
the past, but i've never worked with clobs before.

i can output the data into csv (one/database), but is there any way to batch
load them into oracle? as far as i can make out, it doesn't sound possible
using sqldr. or am i mistaken?

any advice would be appreciated!
Jul 19 '05 #1
1 2589
"Rachel Pevtzow" <rs*@soton.ac.u k> wrote in message news:<c6******* ***@aspen.sucs. soton.ac.uk>...
i currently have a few (non-oracle) databases containing personal papers of
wellington, mountbatten, etc. i'm thinking about moving it into oracle, but
i'm worried about how to get the data in. the limit on character fields in
the current database system is 65000 characters, and we've run into that a
number of times. i've used sqloader to get data into oracle databases in
the past, but i've never worked with clobs before.

i can output the data into csv (one/database), but is there any way to batch
load them into oracle? as far as i can make out, it doesn't sound possible
using sqldr. or am i mistaken?

any advice would be appreciated!


You can create stored procedure and kick in from SQLPlus.

check this sample http://www.oracle-base.com/articles/8i/ImportClob.php

or you can use sql*loader....

http://www.csee.umbc.edu/help/oracle...aload.htm#3627
i like first method, because it's pure plsql and you don't need control files...

jiri
Jul 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
518
by: Rachel Pevtzow | last post by:
i currently have a few (non-oracle) databases containing personal papers of wellington, mountbatten, etc. i'm thinking about moving it into oracle, but i'm worried about how to get the data in. the limit on character fields in the current database system is 65000 characters, and we've run into that a number of times. i've used sqloader to get data into oracle databases in the past, but i've never worked with clobs before. i can output...
4
3513
by: Sam | last post by:
Hello everyone, I have around 20 reports in an ASP web-application which connects to a SQL Server 2000 dB, executes stored procedures based on input parameters and returns the data in a nice tabular format. The data which is used in these reports actually originates from a 3rd party accounting application called Exchequer. I have written a VB application (I call it the extractor) which extracts data from Exchequer and dumps the same...
0
1739
by: Fred | last post by:
Hello, I found a CLOB column in a DMS table that programmers were using to store tiny strings (less than a couple kilobytes). Since CLOB columns can only allocate entire kilobytes of space at best (when created with the COMPACT qualifier), I know that this was wasting a lot of space in the long tablespace. I added a VARCHAR(2048) column to that table so it could hold those small strings instead, which allowed me to null out the tiny...
1
1480
by: kacper | last post by:
Hello, Recently I had to connect my application (Delphi, dbexpress) to remote db2 server connected via WAN. (3Mb/s). If I'm not working with clobs - everything works just great - I have an average network transfer of 280 Kb/s. The problem is that when I'm trying to retrieve clobs as well - everything gets slower for ten times or even worser. (Network transfer of an averege 20-30 Kb/s). Any advices?
6
11238
by: Charles Neitzel | last post by:
I'm trying to write a windows application in C# (Using Microsoft Visual C# 2005 Express) that is nothing more than a simple UI with buttons on it. The buttons do various things like running programs and executing registry entries. The majority of my buttons work however, I have come upon a problem. I need a few of the buttons to run DOS batch files, the batch files in turn run program installers (specifically windows update runtime .exe...
1
3241
by: Mitchell Vincent | last post by:
I've had this trouble in every language I've tried for Windows. Apparently the problem is with the underlying controls or something.. When I loop through and use a hidden web gadget to load and summarily print many HTML docs (say, over 5) I get them out of order, some don't print, and some print all unformatted. It's the strangest thing I've seen.. I've always checked to make sure the document was finished loading before issuing the...
3
7164
by: amitabh.mehra | last post by:
Hi I m new to DB2.. I am using DB2 version8. I have a few queries (which i create dynamically) stored in a table. The column which stores them is clob 32k. Each of these query has a ":wf_id" string in 2 places, which i replace with another string (using the replace function in sysfun pkg in db2) before executing them. its something like:
0
1678
by: Starsky | last post by:
Hello everyone! I am spanish and I am developing an application using DB2 v9 and Java. I´m currently trying new things but I have a problem. I can easily do INSERTS from my application into the DB (XML, CLOBS, etc.) but I have problems when I execute: String qDesc="SELECT DESCRIPCION FROM AVION"; Statement pst2 = cx.createStatement(); ResultSet...
6
1998
by: Thomas Guettler | last post by:
Hi, I tried PIL for image batch processing. But somehow I don't like it - Font-Selection: You need to give the name of the font file. - Drawing on an image needs a different object that pasting and saving. - The handbook is from Dec. 2006. What image libraries do you suggest? I think there are these alternatives:
2
2506
by: animedude123 | last post by:
Hey, I was wondering if anyone knew of a way to have a vb.net app that can load a batch file, and run it inside the vb.net app. Something like, when you open the application, you will see a blank window with a big button that says "Start Batch File" and when you click it, the button will "go away" (hide) and the batch file will now be loading in the application. If anyone knows how to do this, it would be a huge help. I'm mostly doing...
0
9589
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9423
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10049
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9997
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
7413
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6675
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5448
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3965
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3565
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.