In one of my Windows form application in asp .net, I am creating tables on daily basis sharp at 00:00 am with name as "data\_YYYY\_MM\_DD" in Oracle database. A large amount of data exist in each table as after every 5 seconds I am writing some useful data into these.

Now consider all tables of month Oct 2016. All will have name like 'data\_2016\_10%'. How can I take backup of only these tables (not backup of entire database) and then drop these tables from the database.