That's you with the commit in the proper truncate table t2 Ģ type array is table of t%rowtype index by binary_integer ħ PRAGMA exception_init(dml_errors, -24381) ġ3 fetch c BULK COLLECT INTO data LIMIT 100 ġ5 FORALL i IN 1. Thats you right now - about 1 truncate table t2 Refer to the above link for how to do this in 8i and create table tĮlapsed: alter table t2 add constraint check_object_idĩ when others then dbms_output.put_line(sqlcode) ġ4 dbms_output.put_line( l_cnt || ' total errors' ) Here I'll show a 9iR2 specific example, uses BULK_EXCEPTIONS and the ability to insert/update from a record. maybe it would be faster to validate the data AND THEN load it.Īt the very very teeny tiny least - use bulk processing. Committing in a cursor for loop for each insert does a couple of things:Ģ) yup, doesn't employ any bulk operations whatsoever.ġ) do anything lots of times and it takes time. 3) NO - in fact, it makes it go slower then it should.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |