Is there a practice of housekeeping the tables in Oracle DB? Means I want to keep records of past 1 year only. Those data which are more than a year will be exported out to a dump file. The current production DB only has the 1 year of data. Can this be done in Oracle? Most of the tables do no have a field for data and time and the housekeeping cannot be done as I cannot write a script to delete data based on time. Does Oracle maintain statistics on each row when the data is updated/created?