oracle 簡單數表數據據備份

Create newtable
as
select *
from ori-table
where create_dt<=trunc(sysdate)-1;