备份Oracle数据库表数据

先备份后删除

 

--备份2019年数据
create table table_name_2019 as select * from table_name a
where a.create_time between to_date('2019-01-01','yyyy-mm-dd') and to_date('2019-12-31','yyyy-mm-dd');

 

--删除
delete from table_name a
where a.create_time between to_date('2019-01-01','yyyy-mm-dd') and to_date('2019-12-31','yyyy-mm-dd');