This is a part of my code. Everything is ok, no error. But I have million of lines to be inserted. I searched the internet for ways to finish my job faster.
What I found, is that insert in table using nologgin and +append, but is not working. Time to insert the same lines in table is the same even I use nologging and append.
create or replace procedure read_files(input varchar2, extensie varchar2) as
........................................
Loop
BEGIN
..............................
UTL_FILE.GET_line(F1,V1);
insert /*+ append */ into alarms(alarm_id,property_name,property_value)
=values(alarm_counter,f_property_name,f_property_value) ;
End loop;
end;
alter table alarms nologging;
execute read_files('occ','cap');
alter table alarms logging;
Steps for my work:
- first compile the procedure
- alter table nologging
- execute procedure
Where is my mistake?
Aucun commentaire:
Enregistrer un commentaire