Make a copy of a table structure and data

create table job_part_old as select * from job_part

Using BETWEEN in oracle dates

select *
from my_table
where trunc(record_insert_date) between to_date('02-Feb-2012', 'DD-MON-YYYY') and to_date('04-Apr-2012', 'DD-MON-YYYY')