HI
I am having problem to load massive data into table . i have around 750000 rows in the
source file in following format
"asdf","1","this is my data"
"asdg","2","This is my data2"
and here are my table definition and load command
create table TERM_DETAILS(
term varchar(20) primary key,
ID integer not null,
details varchar(3000) default 'none')
dataload table TERM_DETAILS IGNORE DUPLICATES infile 'terms.txt'
after executing above commands process is loading around 400000 rows in 10 to 15
minutes and simply hanging. is anyone successfully loaded millions of rows in MaxDB
table.
Your response will be appreciated.
Thanks,
VCB
---------------------------------
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger
