1.append+parallel
insert into /*+append parallel(a,4)*/ into dept2 a nologging select /*+parallel(b,4)*/ * from dept ;
或者
alter table t nologging;
insert into /*+append */ into t select * from dept,emp;
1.append+parallel
insert into /*+append parallel(a,4)*/ into dept2 a nologging select /*+parallel(b,4)*/ * from dept ;
或者
alter table t nologging;
insert into /*+append */ into t select * from dept,emp;