i'm trying to insert large number of rows to the database , about 100,000 record and i want to insert them every 35,000 record, when i fill the heap i success inserting about 34,000 record after that i fail .
any ideas ? any one understand what i'm trying to say !??!!
thanx in advance [ July 04, 2005: Message edited by: moh sak ]
If transaction is an issue and you want to insert 100,000 records in your table then insert them in temp table using small batches then move data to master table. Otherwise I will also prefer using smaller batches as Jeanne said
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
posted 11 years ago
thanks for your replay i'll try it out and it must work since i'll devide the data into smaller chuncks
thanks very much
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads