INSERT /*+ APPEND */ INTO a 
SELECT /*+ PARALLEL(b,4)*/
	b.*
FROM b;

INSERT /*+ APPEND */ INTO a 
SELECT /*+ PARALLEL(b,4)(c,4)*/
	b.*,c.*
FROM b,c where b.id=c.id;

alter session enable parallel dml; 

update /*+ parallel(x,4)*/ all01 x set timee=to_date(riqi||‘ ‘||shijian,‘yyyy-mm-dd hh24:mi:ss‘)
commit;

delete /*+ parallel(x,4)*/ from all01 x  where x.timee=to_date(riqi||‘ ‘||shijian,‘yyyy-mm-dd hh24:mi:ss‘)
commit;

truncate table table_name;