Deletion of millions of rows from a big production table
Hi gurus,
I need help in this direction.
I have a production database on Linux and Database is Oracle Enterprise Database version 10.2.0.2.
I have a very big table containing about 240 million rows. There is no scope to extend disc space for growth since it is close to max out. We need to maintain this database at least an year from now. The data in that table grows very fast. As there is no scope to get extra disc space, the only option is to delete oldest records from the table. Say for example probably I might need to delete 17 millions records out of it.