help with deleting duplicate records from very large table

[Suhen Pather]

List,   I need to delete duplicate records from a very large table (60 millions records +). There would be about 3 million duplicate entries.   What is the quickest way to do this?   The syntax that I am using is delete from invaudee where rowid not in (select min(rowid) from invaudee group by audit_number);   This is taking a long time to run. I cannot see any entries in v$transaction for the delete.   There is no indexes on the INVAUDEE table. I created an index on the primary key column but it still takes forever to run.   I do not have the space to CTAS.   Or should I write the duplicates to an EXCEPTIONS table and perform the delete based on the entries in the EXCEPTIONS table.   Any help would be greatly appreciated.   Suhen