TORALoader dropping/null data

jdredd · Post by **jdredd** » Thu 01 Oct 2009 17:01

Using TORALoader on oracle 10g i have an issue where it will drop data a lot, and sometimes just have complete null values for a row.

I would assume this is due to much stuff being wrote ? If so any fixes, tricks, tips, ect?

Lost a lot of data today with it and having to go to backups and rewrite everything to do individual inserts.. which is a pain as there is close to 100 million records when data dumps are done monthly.

This is Loadmode lmDML as direct wont work?

jdredd · Post by **jdredd** » Thu 01 Oct 2009 18:31

procedure TForm21.Button1Click(Sender: TObject);
var x:integer;
begin
loader.load;
loader.CreateColumns;
for x:=1 to 10000 do
loader.PutColumnData(0,x,inttostr(x));
end;

This was a quick example...

i have a table that only has 1 column that is a text field and has been truncated first.

im dumping the data from 1 to 10000... the end result is

9902 rows deep..

first value in on row 1 is 1320 and last row has 9900...

Row 1982 has the value of 1 .

And there is 1 row where the field is null.

AM i wrong in thinking this is how it should be done?

I did a million rows and 999901 are showing..

jdredd · Post by **jdredd** » Thu 01 Oct 2009 22:04

ok, nm i figured it out.

I was doing the load and then doing the putdata code...

I created a procedure to do it, and then
assigned oraloader.putdata:=myloader;
then .LOAD and it worked...

sigh.