Sunday, September 30, 2018

Parallel DDL and DML (create table as select)

For DDL :

create table APP_SCHEMA2.APP_TABLE2  parallel 15 as select  /*+ PARALLEL(A,15) */ * from  APP_SCHEMA1.APP_TABLE1 A ;

For DML :

Alter session enable parallel dml;

INSERT /*+ APPEND PARALLEL(A,60) */ into APP_USER2.APP_TABLE2 A
select /*+ PARALLEL(B,60) */ * from APP_USER1.APP_TABLE1 B ;

No comments:

Post a Comment