Which mechanism is best for previous data archived in oracle?
If you used the optional feature table partitioning. You could easily drop the previous years partitions without affecting the current year. If it were me I would partition by month and sub partition by hour. You might want to keep more than the current year online. Hence partition by month would allow you to keep a rolling 11 months if you wanted and drop the oldest partition every month.