Deleting data from a partioned table
The second sql statement in the script is basically trying to delete the data from the child table older than 30 days.
delete * from child_table where timestamp < (SYSDATE-30)
First, I am trying to get a better understanding of tables with partitions but I think should I have statements in the script that alters table drop partition after the deletes to effectively remove the data