To View the deleted data you can use below query. This query will retrieve last 6 hours data from your table.
select * from your_table_name as of timestamp to_timestamp(sysdate-(360/1440));
Here (360/1440) means 0.25 of 1 day. i.e. 6 hours.
If you want to retreive data of 1 hour then (1*60 / 1440) hence 60/ 1440.
To copy the deleted data to a new table then use below queries.
create table new_table as select * from retrieving_table_name where 1=2; — This will create new table of same structure
insert into new_table (select * from retrieving_table_name as of timestamp to_timestamp(sysdate-(360/1440)));
It will insert data to new table from the given time stamp.