How to create a backup table with data

To create the table

CREATE TABLE backup_co_reservation_tab

AS  

SELECT * 

FROM customer_order_reservation_tab

WHERE order_no='xxxxxx';

To drop the table

DROP backup_co_reservation_tab;