My problem is that I'm quite new in oracle admin/dev so I need some help pointing me how to limit the number of days of data stored in a table.
I have some datasources that come in files periodically. I'd like to limit the days stored for each table.
My system is Oracle 10g over Solaris 10.
I though in partitions, but I don't know how to refresh date in them to limit data to 'last 5 days' for example.
Please, if you have some link, example or doc it would be great. I don't know what to search in google to solve this... :S
Thanks in advance.