I have live transaction table called t1,t2,t3,t4 which contains data from last 2 years.
my requrement is i want to delete the data which is older than 14 days
and want to backup the deleted data into bkp_t1, bkp_t2, bkp_t3, bkp_t4.
please guide me how can i perform these action in a plsql procedure .
thanks in advance .