01.begin
02. execute immediate 'alter table tb nologging';
03. execute immediate 'drop index ...'; --删除表上的index
04. for i in 1..1000000 loop
05. insert /*+append*/ into tb .....;
06. end loop;
07. commit;
08. execute immediate 'alter table tb logging';
09. execute immediate 'create index ...'; --重新创建表上的index
10.end;
02. execute immediate 'alter table tb nologging';
03. execute immediate 'drop index ...'; --删除表上的index
04. for i in 1..1000000 loop
05. insert /*+append*/ into tb .....;
06. end loop;
07. commit;
08. execute immediate 'alter table tb logging';
09. execute immediate 'create index ...'; --重新创建表上的index
10.end;