1.direct+parallel
alter session enable parallel dml;
insert /*+ append parallel(XXXX,default)*/ into XXXX select * from YYYY;
2.direct+parallel
create table XXXX parallel as select * from YYYY;
3.direct+parallel
alter session force parallel dml;
alter session force parallel ddl;
create table XXXX as select * from YYYY;
4.direct
create table XXXX as select * from YYYY;
insert /*+ append */ into XXXX select * from YYYY;
[@more@]
alter session enable parallel dml;
insert /*+ append parallel(XXXX,default)*/ into XXXX select * from YYYY;
2.direct+parallel
create table XXXX parallel as select * from YYYY;
3.direct+parallel
alter session force parallel dml;
alter session force parallel ddl;
create table XXXX as select * from YYYY;
4.direct
create table XXXX as select * from YYYY;
insert /*+ append */ into XXXX select * from YYYY;
[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23590362/viewspace-1034007/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23590362/viewspace-1034007/