oracle 把一张表的数据放入另一张表

insert into temp_message(id,pk_id,recevetime,speed,flow,occupy,timelength)
select m.id,m.pk_id,m.recevetime,m.speed,m.flow,m.occupy,m.timelength from message m where id =1;