Hi,
I have to delete records which are older than 6 months in a audit table. The number of rows older than 6months is 40 million.
A direct delete is running out of rollback segment space, though I have added alot of space and I don't know if it is the right way to do it.
In order to issue commits, I have to use cursors. I think it will take forever to complete.
The option of creating a temporary table, truncating the audit table and inserting from the temp back to audit is my last option.

Can anyone suggest a easier and faster way to do this?

Thanks
Vj