create table bak_yy_so_busi_log_577a_201706 nologging as
select /*+parallel(a,10)*/busi_log_id,parent_id,create_date,a.org_id,op_id,bill_id,cust_id,business_id,
customer_order_id from wzsc.F00_SO_BUSI_LOG_577_201706 a,tmp_zzy_test1 b where a.org_id =b.org_id
select /*+parallel(a,10)*/busi_log_id,parent_id,create_date,a.org_id,op_id,bill_id,cust_id,business_id,
customer_order_id from wzsc.F00_SO_BUSI_LOG_577_201706 a,tmp_zzy_test1 b where a.org_id =b.org_id
10个进程并发 nologging模式