/* -- FLASHBACK TABLE...TO BEFORE DROP --	*/
drop table order_items;

SELECT order_id, line_item_id, product_id
FROM order_items

FROM order_items
*
ERROR at line 2:
ORA-00942: table or view does not exist

flashback table order_items to before drop;
Flashback complete.

SELECT order_id, line_item_id, product_id FROM order_items;

ORDER_ID 	 LINE_ITEM_ID 	  PRODUCT_ID
---------- 	 ------------ 	  ----------
	2355 				1			2289
	2356 				1 			2264
	2357 				1 			2211
	2358 				1 			1781
	
	
drop table order_items;


/* --- RECUPERANDO E JA RENOMEANDO --- */
flashback TABLE order_items TO BEFORE DROP rename TO order_items_old_version;

select order_id, line_item_id, product_id from order_items_old_version;

ORDER_ID 	 LINE_ITEM_ID 	  PRODUCT_ID
---------- 	 ------------ 	  ----------
	2355 				1			2289
	2356 				1 			2264
	2357 				1 			2211
	2358 				1 			1781

hostgator