SQL & PL/SQL

Hi,

Hi have a problem regarding the bulk insert.

I have 4 tables and each table has 16 partitions and each table near 2,00,000 records i am inserting

Previously i tried bulk insert ..


open insert_tab1;

loop

fetch insert_tab1 bulk collect into type_insert_tab1 limit 40000; --- fetch is near 2,00,000 records

forall i in 1..type_insert_tab1.count
insert into tab1 values type_insert_tab1(i);

commit;

exit when insert_tab1%notfound;

end loop;


Now similar insert i did for three other tables with the commit statementand in each table approx 2,00,000 records we are inserting.

But i got snapshot too old error.how i can modify this to reduce commit and buffer use an dless execution time.

or shall i take only insert into tab1
(col1,
..
col7)
select *from tab2;


Thanks in advance