Search This Blog

Friday, April 13, 2007

Parallel Direct Load Insert DML

Example

create table table2 ( id number,name varchar2(10));

select degree from user_tables where table_name='TABLE2';

ALTER TABLE michael.table2 PARALLEL ( DEGREE 2 );

alter session enable parallel dml;


Insert /*+ Append parallel(table2,2) */ into table2
select * from table1;


truncate table table2 reuse storage