We are currently on oracle 11g rel2.over time oracle tables grown too big and having multi millions of rows.
To improve performance it is agreed by business to archive data older than 5 years and keep only the latest 5 years in current tables.
Business team identified the tables and advised to create new tables like tablename_hist and put the data of tablename into tablename_hist.
Student tables archive will be student_hist.
The question is how can I identify older data in a table which is older than 5 years?
Is there something buit in within oracle?